Maybe

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

--

HTH

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


"S1" wrote in message
...
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