Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find end of list - new problem
Hello again!
Recently I had this problem: 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. ... and tried the following: iLastRow = Cells(Rows.Count,"A").End(xlUp).Row It works in general, but unfortunately not in my document. I can't find the error. Does anybody know what the problem might be? iLastRow always turns out as 1 which is incorrect. Maybe excel cant't find data, but I don't know why ... Thanks for helping me, Maria |
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 |