Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to select values in a column with blanks
Suppose in the range A1:A10 I have values that are the days of the week, but
cells A3 and A7 are blank. How do I write a VBA statement that will select a range that includes all the values in column A (assuming there is no other data in the worksheet)? I seem to remember there being an xlUp or xlDown method, but I'm not sure of the syntax. If I'm not mistaken, there should be a way to code it so that it will work for a list of any size. Thanks for any suggestions! -gk- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to select values in a column with blanks
Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp)).Select
-- Vasant "TBA" wrote in message ... Suppose in the range A1:A10 I have values that are the days of the week, but cells A3 and A7 are blank. How do I write a VBA statement that will select a range that includes all the values in column A (assuming there is no other data in the worksheet)? I seem to remember there being an xlUp or xlDown method, but I'm not sure of the syntax. If I'm not mistaken, there should be a way to code it so that it will work for a list of any size. Thanks for any suggestions! -gk- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to select values in a column with blanks
Vasant,
Thank you very much! Now suppose on the same worksheet I have another list in column B, and this list has blanks also. How would I then select just that list? I tried manipulating the code in your reply to work for column B, but it ended up selecting both lists. As usual, all help greatly appreciated. -gk- "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp)).Select -- Vasant "TBA" wrote in message ... Suppose in the range A1:A10 I have values that are the days of the week, but cells A3 and A7 are blank. How do I write a VBA statement that will select a range that includes all the values in column A (assuming there is no other data in the worksheet)? I seem to remember there being an xlUp or xlDown method, but I'm not sure of the syntax. If I'm not mistaken, there should be a way to code it so that it will work for a list of any size. Thanks for any suggestions! -gk- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to select values in a column with blanks
Nevermind, got it! :)
-gk- "TBA" wrote in message ... Vasant, Thank you very much! Now suppose on the same worksheet I have another list in column B, and this list has blanks also. How would I then select just that list? I tried manipulating the code in your reply to work for column B, but it ended up selecting both lists. As usual, all help greatly appreciated. -gk- "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp)).Select -- Vasant "TBA" wrote in message ... Suppose in the range A1:A10 I have values that are the days of the week, but cells A3 and A7 are blank. How do I write a VBA statement that will select a range that includes all the values in column A (assuming there is no other data in the worksheet)? I seem to remember there being an xlUp or xlDown method, but I'm not sure of the syntax. If I'm not mistaken, there should be a way to code it so that it will work for a list of any size. Thanks for any suggestions! -gk- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count values in array of data where no blanks in one column | Excel Worksheet Functions | |||
Counting multiple values (including blanks) in one column | Excel Discussion (Misc queries) | |||
In Exel how can I select and sum the top two values in a column? | Excel Discussion (Misc queries) | |||
From Column select Values to sum | Excel Worksheet Functions | |||
Select top 5 in column A, sum values in B | Excel Worksheet Functions |