| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear contents of last two rows of data on sheet
Hi.
I'm using v 2003. I need a couple of lines of code that will delete or clear the contents of the last two rows on a sheet that have data in them. In other words, if there are 800 lines of data and I want rows 799 and 800 to be deleted or contents cleared. The number of the last row varies everytime I run the report. Can anyone help? Thanks! Dani |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duplicate data in range clear contents | Excel Programming | |||
| Macro or VBA to Clear Contents of Rows By Date (Starting At A5) | Excel Programming | |||
| clear contents on linked sheet | Excel Programming | |||
| Clear rows with no data? | Excel Programming | |||
| Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
Threaded Mode
