Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Fill Cell

Posted on 2011-02-25
4
Medium Priority
?
180 Views
Last Modified: 2012-05-11
Hi,

I have atatched a ss where you can see the highlighted cell is blank. I would like a piece of code that runs through Column C and says "if A2 is not blank, and C2 is Blanks, "No Source Code"

Thanks
Seamus
Example.xls
0
Comment
Question by:Seamus2626
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
StephenJR earned 2000 total points
ID: 34979037
Seamus - do you mean like this?
On Error Resume Next
Intersect(Columns(1).SpecialCells(xlCellTypeConstants).Offset(, 2), Columns(3).SpecialCells(xlCellTypeBlanks)).Value = "No source code"
On Error GoTo 0

Open in new window

0
 

Author Closing Comment

by:Seamus2626
ID: 34979072
Smashing!! Thanks

Seamus
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34979073
Stephen - nice. :)
0
 
LVL 24

Expert Comment

by:StephenJR
ID: 34979499
Thank you both!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question