Hi all.

I just need one line for VB. It is just to say if any of the cells in a range have data in them, then.....


If (Range of Cells).Value <> "" Then.........

But this isn't right. Is there one line in VBA that means the value of any of the cells?


Thanks

Wengang