Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
worked purfectly!
Thanx... When I become a millionaire, I'm buying you a Krystal! With Cheese! (Or a White Castle). |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Keep getting error with this part..... Range(cell, Cells(cell.Row, "g)).Copy sh.Cells(NewRow, 1) |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |