empty ranges

[S1]

hi all,
what would be the vb code to chech a range to see if
anything (data) was there. say range j12:x12.

thank you in advance
S1

 

[Bob Phillips]

Maybe

If Application.CountA(Range("J12:X12"))> 0 Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

thank you Bob
S1

-----Original Message-----
Maybe

If Application.CountA(Range("J12:X12"))> 0 Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)





.