• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

Fill Cell

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
Seamus2626
Asked:
Seamus2626
  • 2
1 Solution
 
StephenJRCommented:
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
 
Seamus2626Author Commented:
Smashing!! Thanks

Seamus
0
 
Rory ArchibaldCommented:
Stephen - nice. :)
0
 
StephenJRCommented:
Thank you both!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now