Hi,
When pressing Ctrl + END you are taken to the end of the current data range.
I have a spreadsheet with a macro that removes all blanks, reducing 70 rows down to 30 rows. When i press Ctrl+END it still takes me to row 70 although all that data has now been deleted. How can i set the end of data range...(want to apply a formula in column A and have it copy down to the end of range which in practice is row 30, but in reality started as being row 70)
Tany thanks
T
When pressing Ctrl + END you are taken to the end of the current data range.
I have a spreadsheet with a macro that removes all blanks, reducing 70 rows down to 30 rows. When i press Ctrl+END it still takes me to row 70 although all that data has now been deleted. How can i set the end of data range...(want to apply a formula in column A and have it copy down to the end of range which in practice is row 30, but in reality started as being row 70)
Tany thanks
T