hi,
i did some research.
Counta is for text/other
count is for numbers
however changing to count and formating all the qpa's to
number does no good either.
aplication.count("qpa1") now returns zero regarless of
what is in the range.

-----Original Message-----
hi bob
I high lighted the range and deleted. but even in the
other ranges(as it moves down the sheet) it will return 1
even if there are 3,4 or 5 number in the range. it
returns
1 regardless.


-----Original Message-----
There must be something in the range if it is 1.

--

HTH

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


"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


.

.