Hello Friends,
The code is copying two non-contiguous columns.
How to tell the code to look at last used cell in Columns B & D in said case i.e. from B2 to the last used cell and from D2 to the last used cell
Any help would be appreciated
Regards,
Humayun
The code is copying two non-contiguous columns.
How to tell the code to look at last used cell in Columns B & D in said case i.e. from B2 to the last used cell and from D2 to the last used cell
Code:
Sub Copy()
Range("B2:B100,D2:D100").Copy
Range("G2").PasteSpecial Paste:=xlPasteValues
End Sub
Any help would be appreciated
Regards,
Humayun