Macro to select range depending cell value

[mDieli]

I'm looking for a macro to select a range of cells depending a cell value.

For example:

If cell A1=25, then it needs to select the range B1:B25,
If cell A1=3, then it needs to select the range B1:B3.

I don't know if it is even possible.

Thanks!

 

[VoG]

Try

Sub test()
Range("B1:B" & Range("A1").Value).Select
End Sub

 

[mDieli]

Thanks a lot!

Didn't expect it would be THAT simple...

 

[ganeshpoojary05]

Hi,

use the below code


a = Range("a1")
b = "B1:B" & a
If a > 0 Then
Range(b).Select
End If