0

Basically when I do this on Excel VBA it works great:

Range(Cells(2, "K"), Cells(FilaFinalK, "K")).Select

But when I declare it as a variable and then select it, it gives me error 91.

Dim List As Range 
List = Range(Cells(2, "K"), Cells(FilaFinalK, "K"))
List.Select

¿Can any one help me sith this please?

Improve this question
3
  • 3
    You need set List =..., range is an object, and all objects need to be set. Commented Oct 17, 2022 at 11:50
  • jeje that was easy to fix! haha thank you!! Commented Oct 17, 2022 at 11:52
  • 1
    Difference between Dim and Set Commented Oct 17, 2022 at 11:58
Related questions
1
Is possible to limit a row selection?
13
How store a range from excel into a Range variable?
1
Excel VBA: 2 dimensional array search, check to see if cell is empty
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.