PDA

View Full Version : [SOLVED] Need to change code in bottom line



Feebles
06-13-2016, 12:23 PM
My purpose is copying last cell in worksheet Betsheet.column "b" to last empty cell in worksheet.Lists col "D" which has a range name of "SelectDate"
I am trying to adapt this code to suit my needs.
it is copying last cell in B col to worksheet.Lists
and it does so to G1 offset 2
can sombody please help to change the last line to suit
All help is always appreciated
Regards
Graham

Feebles
06-13-2016, 12:58 PM
Solved! changed it my trying, trying etc etc!
ws2.Range("D5").End(xlDown).PasteSpecial xlPasteValuesAndNumberFormats

that was the answer
Cheers all

Feebles
06-13-2016, 01:50 PM
Noooo, this is not the answer, I was too rash here
it is overwriting the last row. I need to add an offset to that code, so need help there please
Regards
Graham

Paul_Hossler
06-13-2016, 01:54 PM
Guessing




ws2.Range("D5").End(xlDown).Offset(1,0).PasteSpecial xlPasteValuesAndNumberFormats

Feebles
06-13-2016, 05:02 PM
Ahhh, Paul, this works fine thanks very much
Appreciate it
Regards
Graham