Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros - How to tell if cells in a column are blank?
Hi there,
I have a problem that I can't solve and I was wondering if anyone knows a way of doing this? It's very simple really but for some reason my VBA manual doesn't deal with anything like it. I want to identify where column A contains a null value, and in each case of a null I want to delete the entire row that the null occurs in. (At the very least I need to delete the cells in A through C). I was also wondering if there is a quick way of highlighting the area that contains data instead of highlighing the whole worksheet or the whole column or row? I would like to do this in both a Macro and in general if possible as I'm often dealing with data in 1000's of rows so it would be good if I could do something similar to Ctrl+A rather than tediously finding the bottom and highlighting up. Any help is gratefully appreciated. Cheers, Natasha. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros - How to tell if cells in a column are blank?
Have a look at specialcells in vba HELP
"Natasha" wrote in message ... Hi there, I have a problem that I can't solve and I was wondering if anyone knows a way of doing this? It's very simple really but for some reason my VBA manual doesn't deal with anything like it. I want to identify where column A contains a null value, and in each case of a null I want to delete the entire row that the null occurs in. (At the very least I need to delete the cells in A through C). I was also wondering if there is a quick way of highlighting the area that contains data instead of highlighing the whole worksheet or the whole column or row? I would like to do this in both a Macro and in general if possible as I'm often dealing with data in 1000's of rows so it would be good if I could do something similar to Ctrl+A rather than tediously finding the bottom and highlighting up. Any help is gratefully appreciated. Cheers, Natasha. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros - How to tell if cells in a column are blank?
Natasha, "I want to identify where column A contains a null value" by null
do you mean 0 or blank or both?, as far as selecting a range try crtl+shift+ down arrow and see if this will do what you want -- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Natasha" wrote in message ... Hi there, I have a problem that I can't solve and I was wondering if anyone knows a way of doing this? It's very simple really but for some reason my VBA manual doesn't deal with anything like it. I want to identify where column A contains a null value, and in each case of a null I want to delete the entire row that the null occurs in. (At the very least I need to delete the cells in A through C). I was also wondering if there is a quick way of highlighting the area that contains data instead of highlighing the whole worksheet or the whole column or row? I would like to do this in both a Macro and in general if possible as I'm often dealing with data in 1000's of rows so it would be good if I could do something similar to Ctrl+A rather than tediously finding the bottom and highlighting up. Any help is gratefully appreciated. Cheers, Natasha. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros - How to tell if cells in a column are blank?
Paul B wrote:
Natasha, "I want to identify where column A contains a null value" by null do you mean 0 or blank or both? . . . Or something else? Some of the possibilities a #NULL!, Empty, the empty string (i.e., =""), 0, ', a blank space, Left("A",0) Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill blank cells in a column | Excel Worksheet Functions | |||
I can't autofill cells in a column if blank cells in between | Excel Worksheet Functions | |||
Removing blank cells from a column | Excel Worksheet Functions | |||
HELP: Last row of the column containing blank cells between non-blank cells | Excel Worksheet Functions | |||
how can i fill blank cells in column with abc while the right col. | Excel Discussion (Misc queries) |