quick syntax help for empty cells 1

[Luis939]

Really quickly, is there a way to say in code
IF my activecell has no value (either nothing at all "", or one empty space " " or more empty spaces " "
basically i dont want to encounter a cell that doesnt have a visible value in it

I tried if activecell.value = empty, but that doesnt account for more than one empty character, i want something to account for all possible blank characters or blank strings of any length, thanks!!!

 

[xlbo]

how about
if trim(activecell.text) = "" then.....

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[dan1967]

I would try:

If RTrim(LTrim(ActiveCell.Value)) = "" Then

Dan.

 

[Luis939]

Haha oh God i feel so stupid, its like the answer is right before my face...i think my problem is that i place too much emphasis on affect what is in the right side of the "=", forgetting that I can just as well apply a formula to the argument that is in the left side of the equal sign....thanks XLBO!!!

 

[xlbo]

Don't feel stupid - as long as you remember this next time, it was a worthwhile exercise....

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244