Forum Discussion
peysg
Jul 28, 2022Copper Contributor
Using lastrow variable in range
Hi, I have created a last row variable in VBA and want to use them in range to copy a range of SPECIFIC COLUMN (e.g. B1 to last row and E to last row) but couldn't get it to work (See code in red). T...
peysg
Jul 28, 2022Copper Contributor
Apologies, this doesnt work. It still copy column B to E. I want to skip column C & D
HansVogelaar
Jul 28, 2022MVP