| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add code to paste data to next available row
rw was set to to so I originally used rw and then took out all the lines with
rw except this one from LastRow = sh.cells(rows.count,rw).end(xlup).row to LastRow = sh.cells(rows.count,"B").end(xlup).row "J.W. Aldridge" wrote: Thanx.... But getting Application defined error or object defined error on this line LastRow = sh.Cells(Rows.Count, rw).End(xlUp).Row |
| 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
