Forum Discussion

peysg's avatar
peysg
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). T...
Macros and VBA
Harun24HR's avatar
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's avatar
    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's avatar
      HansVogelaar
      MVP
      Jul 28, 2022

      peysg 

      Set table = Worksheets("Database").Range("B1:B" & lastrow & ",E1:E" & lastrow)
      • peysg's avatar
        peysg
        Copper Contributor
        Jul 28, 2022
        Apologies, this doesnt work. It still copy column B to E. I want to skip column C & D

Resources