$$Excel-Macros$$ search until a blank cell is found.

2010-11-11 Thread Lakshitha
i have a column filled with month names. but not in order here and there. not in a list. I want to search for all "sep" in that whole column and put the values next to it another column. but How to end the loop once it reach the last "sept" in the column. In other words howt to stop it from endles

$$Excel-Macros$$ finding the last row

2010-10-30 Thread Lakshitha
I have a excel sheet where, data is distributed. I want my macro to find the last non empty row in the sheet. what is the best way to find it. In several places i saw that , "go to special --> last cell" is not that reliable. -- ---