empty variable range

S

S1

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
 
J

Jim May

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)





.
Click to expand...
 
B

Bob Phillips

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

--

HTH

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

Guest

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.
 
G

Guest

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.
 
B

Bob Phillips

Want to send me the workbook, and I can take a look.

--

HTH

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