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)


"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


.

"S1" wrote in message
...
hi all,
I posted this yesterday but i failed to mention something
and the advise i got is not working. my fault.
how can i tell if a range is empty.
i have a do loop that i want to check a range as it goes
down the sheet. if the range is empty then color it else
don't. the range is assigned to a variable as it moves
down the sheet.
what i am using now is
application.counta("qpa1")
this counts 1 regardless of what is in the range.
anyone have hints, suggestions, directions?
any help would be appreciated.
S1