Should be Simple...

[Craig Coope]

Hi,

I have the line of code

If Range("C7").Value = True Then

Basically I want the instruction after this code to happen if there is
anything displayed in the cell C7. Now the above code doesn't work but I
know that it is almost correct because if I type "yes" into cell C7 and then
change the code to

If Range("C7").Value = "yes" Then

it works, but I can't use this as the cell will not always contain the word
"yes" What is the correct syntax for saying "if the cell contains data"?

Thank You...

Craig...

 

[macropod]

Hi Craig,

Try:
If Range("C7").Value <> "" Then

Cheers

 

[Craig Coope]

Hi Craig,

Try:
If Range("C7").Value <> "" Then

Cheers

Ahhh...I knew it would be that simple!

Cheers...