Home |
Search |
Today's Posts |
#1
|
|||
|
|||
empty variable range
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 . |
#5
|
|||
|
|||
yes yes, i know. i say i posted yesterday.
-----Original Message----- 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 . |
#6
|
|||
|
|||
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
CountIF cells are not empty | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
range name | Excel Worksheet Functions | |||
variable range countif | Excel Worksheet Functions |