Hi, so i have working code which will copy column A from one sheet to column B on another sheet.
The VBA is the following
However the range "A3:A100" needs to be updated to pick up the correct column from another sheet.Please Login or Register to view this content.
I have EXCEL code for this,
This will return the letter A. Is there any way to incorporate this into the VBA script, on this line?Please Login or Register to view this content.
In order the make sure the range A3:A100 uses the correct column.Please Login or Register to view this content.
Thanks in advance
Book1.xlsm
Bookmarks