| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Paste
Writing a macro and trying to copy several cells from sheet 1 and then
paste into sheet 2 while not pasting over existing data. Is there a way to auto select the next blank cell in the column in sheet 2 and paste. Say if A1 is not blank, then auto select A2 instead and so on. I'm using sheet 1 as the data entry sheet and then sheet 2 to collect the data for creating charts, etc. Don't want to paste over existing data. Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
| Cut and Paste using Macro gives paste special method error | Excel Programming | |||
| Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming | |||
| Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
Threaded Mode
