canthony24
Board Regular
- Joined
- Mar 24, 2016
- Messages
- 70
So hopefully I can explain this...
I have a worksheet with data in cells from A3:AY across and down to A299. However we have formulas down to A500:AY. If we put our selection on A3 and turbo button down it shoots us to A500 since we have formulas in every cell.
I'm trying to figure out a macro to delete all those empty cells from A299 and below, however this report will be used by a lot of people and they will be dumping their data into the report, so not everyone will have data that goes down to A299.
Essentially, I'm hoping to find a macro to delete the empty cells from the end of the data line no matter how big the paste is. It just deletes/clears the formulas from the last line of data going down.
I have a worksheet with data in cells from A3:AY across and down to A299. However we have formulas down to A500:AY. If we put our selection on A3 and turbo button down it shoots us to A500 since we have formulas in every cell.
I'm trying to figure out a macro to delete all those empty cells from A299 and below, however this report will be used by a lot of people and they will be dumping their data into the report, so not everyone will have data that goes down to A299.
Essentially, I'm hoping to find a macro to delete the empty cells from the end of the data line no matter how big the paste is. It just deletes/clears the formulas from the last line of data going down.