Selecting row using long variable (Excel VBA)

Question

Dim finishedStartRow As Long
Rows("finishedStartRow:finishedStartRow").Select

I'm trying to select the row 481805 using the finishedStartRow variable. I'm getting a type mismatch error because .Select can only handle Integers. Is there a workaround? Thanks!

Try: `Rows(finishedStartRow).Select`. – Fadi Feb 22 '17 at 19:23 — Fadi, Feb 22 '17 at 19:23

score 2 · Answer 1 · edited May 23 '17 at 10:29

The dim'med var should not be included in quotes.

Dim startStartRow As Long
Dim finishedStartRow As Long

startStartRow = 2
finishedStartRow = 481805

'all of these are valid for variations on selection¹
Rows(finishedStartRow).Select
Rows(finishedStartRow & ":" & finishedStartRow).Select
Rows(startStartRow & ":" & finishedStartRow).Select

¹ _{See How to avoid using Select in Excel VBA macros for more methods on getting away from relying on select and activate to accomplish your goals.}

Selecting row using long variable (Excel VBA)

1 Answers1