| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear All from last row of data down
Hi,
Every time I copy and paste values from one workbook to another, I end up overinflating the size of the second file considerably. The data from the first workbook is filtered, and when I copy, I copy the columns. For some reason, it picks up something from the blanks in the first workbook and copies into the second, even though I paste values?? (I have even tried Clear All from the blanks of the first file) I just need a piece of code that finds the last row of data, and €˜clears all below that row. Many thanks for help Regards John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to clear data | Excel Worksheet Functions | |||
| Create a Clear button to clear unprotected cells | Excel Programming | |||
| clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
| Clear out data | Excel Discussion (Misc queries) | |||
| Creating a graph with existing data...clear data after save | Excel Programming | |||
Threaded Mode
