Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find end of list
Hello again!
To explain my problem properly: My macro fills in data into a column with the length of the range called "vol1" daily. Sometimes, if no value is found from the data sources, it leaves cells blank. Now, I'd like to find the end of the list (last entry) but can't use the specialCells (xlCellTypeBlanks) command (because an empty cell might not be the last entry). Is there any other option? I think the macro needs to check if from one empty cell on all following cells (until the end of the range) are empty too. I hope someone can help! Thanks again, Maria |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find end of list
iLastRow = Cells(Rows.Count,"A").End(xlUp).Row -- HTH RP (remove nothere from the email address if mailing direct) "Maria" wrote in message ... Hello again! To explain my problem properly: My macro fills in data into a column with the length of the range called "vol1" daily. Sometimes, if no value is found from the data sources, it leaves cells blank. Now, I'd like to find the end of the list (last entry) but can't use the specialCells (xlCellTypeBlanks) command (because an empty cell might not be the last entry). Is there any other option? I think the macro needs to check if from one empty cell on all following cells (until the end of the range) are empty too. I hope someone can help! Thanks again, Maria |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find end of list
Thank you! It worked!
-----Original Message----- iLastRow = Cells(Rows.Count,"A").End(xlUp).Row -- HTH RP (remove nothere from the email address if mailing direct) "Maria" wrote in message ... Hello again! To explain my problem properly: My macro fills in data into a column with the length of the range called "vol1" daily. Sometimes, if no value is found from the data sources, it leaves cells blank. Now, I'd like to find the end of the list (last entry) but can't use the specialCells (xlCellTypeBlanks) command (because an empty cell might not be the last entry). Is there any other option? I think the macro needs to check if from one empty cell on all following cells (until the end of the range) are empty too. I hope someone can help! Thanks again, Maria . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find a find a list of possible inputs to sum a known amt? | Excel Discussion (Misc queries) | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
How to find and list duplicate values in a list? | Excel Programming | |||
How to find and list duplicate values in a list? | Excel Programming |