Forum Discussion
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 No VBA expert here, but why not just:
Set Table = Worksheets("Database").Range("B1:E" & lastrow)
?
I would like to skip column C and D