For loop to select entire rows within the loop

Hi All, I would like to select all the from rows 6 to rows 9. However, the for loop below somehow selects only row 9. Therefore, how do i amend the code below so that row 6 to row 9 is select...

excel

Formulas and Functions

Macros and VBA

plsfix
Nov 08, 2022
Replace the for loop with this. I'm not very familiar VBA so it isn't clean, but it works.

With ws Range("A" & find_no & ":A" & find_period).EntireRow.Select End With

plsfix

Brass Contributor

Nov 08, 2022

Replace the for loop with this. I'm not very familiar VBA so it isn't clean, but it works.

With ws
        Range("A" & find_no & ":A" & find_period).EntireRow.Select
End With

hrh_dash
Iron Contributor
Nov 08, 2022
,it works perfectly. thanks for the help!

Forum Discussion

For loop to select entire rows within the loop

Resources