Solved

Fill Cell

Posted on 2011-02-25
4
177 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
StephenJR earned 500 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

688 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