Chose Range of rows using two variables

[cogswel__cogs]

I want to write in vba code to select range of rows for example.

X = 5
y = 9

rows(x:y).select

How would I write it?
I've tried

I have tried

rows(x & ":" & Y).select

But it does not work.

All help is greatly apprciated.

 

[Joe4]

Works just fine for me:

Sub MyTest()

    Dim x As Long, y As Long
    
    x = 5
    y = 9
    
    Rows(x & ":" & y).Select
    
End Sub

 

[plettieri]

Hello cogswel,

You might try this

To select a range of rows in VBA using variables for the start and end rows, you need to use the Rows property of the active worksheet and convert the range to a string. Here's the correct way to write it:



Dim x As Long
Dim y As Long

x = 5
y = 9

Rows(x & ":" & y).Select

The issue with your attempt was likely the capitalization of the variable Y. In VBA, variable names are case-insensitive, so Y and y refer to the same variable. It's a good practice to be consistent with your capitalization.

Here's a breakdown of why this works:

1. x & ":" & y creates a string like "5:9"
2. Rows("5:9") is equivalent to selecting rows 5 through 9
3. The Select method is then applied to this range

If you want to make your code more robust, you could also use the following alternative:



Range(Rows(x), Rows).Select

This approach uses the Range object to select from row x to row y, which can be slightly more flexible in some situations.



Hope this helps,

Plettieri

 

[cogswel__cogs]

Many thanks worked perfectly