Select 2 non-adjacent rows

[Ezguy4u]

Ok so I need a vba program that will select two non-adjacent rows and the row numbers need to be variables. Attached is an example of what I have so far. Range("2:2,4:4").Select won’t let me substitute variables for the 2 and 4. Rows(2).Select and Rows(4).Select I could substitute variables for the 2 and 4 but I don’t get 2 non-adjacent rows. Any help will be appreciated. Thanks in advance.

Sub Select1()
Dim N As Integer
Dim M As Integer

Range("2:2,4:4").Select

N = 2
M = 4

Rows(N).Select
Rows(M).Select

End Sub

 

[Ezguy4u]

There is a lot to unpack here for me, someone who wants to learn as much as I can. I am definitely copying all these examples and saving them to my tool box. Thank you everyone for sharing your knowledge.

 

[Peter_SSs]

You're welcome. Glad we could help.