Select specific range starting with active cell

[Brink9]

I’m trying to figure out how to select a specific range using vba code. I know how to select the active cell. Once I have the active cell, I’d like to select a range from the active cell to a fixed, non changing cell. For example, if the active cell is a14 and the fixed cell is i49. The active cell can change from a14 to a49, but i49 must stay fixed.

 

[My Aswer Is This]

Try this:

Sub Test()
'Modified 6/7/2018 10:45 PM  EDT
Application.ScreenUpdating = False
Range(Cells(ActiveCell.Row, ActiveCell.Column), Cells(49, ActiveCell.Column)).Select
Application.ScreenUpdating = True
End Sub

 

[My Aswer Is This]

I was a little confused about this:

The active cell can change from a14 to a49, but i49 must stay fixed.​

It appears your saying the column may change but not the row.

you used a then i

 

[Brink9]

Thanks for the quick response My answer is this! Maybe this will make more sense. Let’s say I have a range of cells I’m working with (A14:I49) in which data entries can happen in (A14:A49). Then data is entered only into cells A14, A15, and A16 for example. I then want to use a macro to find the active cell next in line (A17, in this case), and then select a range from the active cell to cell “I49”. Basically I just want to select a range that looks like (“ActiveCell:I49)

Thanks

 

[Brink9]

Basically I’d like to select a range that looks like (“ActiveCell:I49”). Not sure if this is possible, but was curious if it could be found using a macro.

 

[jolivanes]

Range(ActiveCell.Address(0, 0) & ":I49").Select

The suggestion by My Answer Is This will work if you change it to

Range(Cells(ActiveCell.Row, ActiveCell.Column), Cells(49, 9)).Select

 

[Brink9]

Thanks Jolivanes!

Works perfectly!!