lr.copy

Hi Everyone, Here i am trying to copy data from one sheet to another, where i need to exclude one particular column from copy sheet Like : Think i have 2 sheets( with names as "Combined","HSR") from HSR i need to copy all the data to Combined sheet excluding column "D" values...

I have data in various cols I have written code to copy the data in Col j & Col L and to paste value in S1 I get a run time error-Application-defined or object-defined error The following code is highlighted .Range("J1:J, L1:L" & lr).Copy See full code below Sub...

HI On the "Dump" tab, columns A, B, C, F & G ignore the last row of data being my header and paste it over the top and same happens with sheet "FL" data, that it pastes over the top over the top of the last row. So it appears the .End(xlUp) does not work for sheets "AS" and "FL", any idea...

I have written the following code to copy data from row 1 to the last row containing data in Cols O, Q:U However I get application defined or object defined error sheets(2).Range("O1:O", "Q:U" & LR).Copy Destination:=Sheets(3).Range("A1") It would be appreciated if someone could kindly...

I have quick question.. Hi All, I have define name to entire column. Now while doing code, I want to write in a code like this.. instead of wk1.Range("G1:G" & LR).Copy I want it like this.. wk1.Range(cExpirationDate).Copy Please suggest..

Sub Rectangle1_Click() Dim lr As Long Here is my code. However, it only copies the columns from the 1st sheet. How can I add the data from the 2nd sheet below the copied data from the 1st sheet into the summary (RAID)? Workbooks("Source").Activate lr = Cells(Rows.Count, 3).End(xlUp).Row...