Forum Discussion

Copper Contributor

Jul 28, 2022

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). The code works if I replace last row with integer...

Kindly assist.

7 Replies

Riny_van_Eekelen
Platinum Contributor
Jul 28, 2022
peysg No VBA expert here, but why not just:
Set Table = Worksheets("Database").Range("B1:E" & lastrow)

?
- peysg
  Copper Contributor
  Jul 28, 2022
  I would like to skip column C and D
Harun24HR
Bronze Contributor
Jul 28, 2022
peysg
Your use of double quote "" is wrong. Try below line-
Set table=Worksheets("Database").Range("B1:B" & lastrow, "E1:E" & lastrow)
- peysg
  Copper Contributor
  Jul 28, 2022
  This doesnt work, it still copy columns from B to E, i want to skip column C & D
  - HansVogelaar
    MVP
    Jul 28, 2022
    peysg
    
    Set table = Worksheets("Database").Range("B1:B" & lastrow & ",E1:E" & lastrow)

Resources