| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add code to paste data to next available row
You change the B to a G and lost a double quote.
from Range(cell, Cells(cell.Row, "g)).Copy sh.Cells(NewRow, 1) to Range(cell, Cells(cell.Row, "g")).Copy sh.Cells(NewRow, 1) PS: I've been eating white castle for 50 years. I can eat a lot of those small burgers. "J.W. Aldridge" wrote: Keep getting error with this part..... Range(cell, Cells(cell.Row, "g)).Copy sh.Cells(NewRow, 1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy and paste those cells that have data | Excel Programming | |||
| Code to copy and paste those cells that have data | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| Got the Copy/Cut Code But what is the Paste Code | Excel Programming | |||
| VBA code gets lost from workbook if I paste in new data and save??? | Excel Programming | |||
Threaded Mode
