Hi,
I have the following line which should give me the last blank cell in a given column. Unfortunately it seems that the code counts cells which contain formulas as non-empty cells. Is there a way to avoid this?
lastrow = Cells(Rows.Count, "K").End(xlUp).Row
Greetings
Max
I have the following line which should give me the last blank cell in a given column. Unfortunately it seems that the code counts cells which contain formulas as non-empty cells. Is there a way to avoid this?
lastrow = Cells(Rows.Count, "K").End(xlUp).Row
Greetings
Max