Select Cells in Between using Macro

[omairhe]

Hey everyone,

I would like to ask that how can I select all the cells starting from Active Row, Column A up until Active Row, Active Column.

For instance I am at cell G12

What I want is to select A12:G12

Similarly If I am at D19

then select A19:D19

Thank you and will appreciate.

 

[Eric W]

Try:

Range(Cells(ActiveCell.Row,"A"),ActiveCell).Select

 

[omairhe]

Try:

Range(Cells(ActiveCell.Row,"A"),ActiveCell).Select

thank you, I would further appreciate if it is possible for you to make the ActiveCell as the default selected cell inside the bigger selection instead of a cell in column A.

For instance if the user is at G12, the code is run and the range A12:G12 is now selected, But my selection changes from cell G12 to A12 after the code is run, whereas I would like that to be G12.

 

[Eric W]

How about this:

    Set c1 = ActiveCell
    Range(Cells(c1.Row, "A"), c1).Select
    c1.Activate