| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste macro
I am trying to write a bit of code to search for the first blank row in an
excel list then paste a selection at that point in the list then stop. I have managed it to finding the first blank row, but it continues pasting into all the blank cells thereafter. Help please |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and paste macro
does this help
Sub firstblankrow() fbr = Cells(1, 1).End(xlDown).Offset(1).Address Range("a1").Copy Range(fbr) End Sub -- Don Guillett SalesAid Software "Bikernick" wrote in message ... I am trying to write a bit of code to search for the first blank row in an excel list then paste a selection at that point in the list then stop. I have managed it to finding the first blank row, but it continues pasting into all the blank cells thereafter. Help please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Paste Macro | Excel Programming | |||
| 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 | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
Hybrid Mode
