Selecting Cells in Rows Selection

[mjgcancio]

Hi all.

I really don't know how to do this, but I have a spreadsheet at work, with several worksheets.
In sheet "twobuy", I want to select the rows I need and then, with a vba macro, I want excel to select the cells in column "AM" from the selected rows, so I can make some calculations.

Is that possible? I really appreciate a little help with this.

Thanks in advanced, best regards,
MC

 

[MARK858]

Try...

Sub mjgcancio()
Intersect(Selection, Columns("AM")).Select
End Sub

 

[mjgcancio]

Try...

Sub mjgcancio()
Intersect(Selection, Columns("AM")).Select
End Sub

Great it worked.
Many thanks Mark858.

Best regards,
MC

 

[MARK858]

You're welcome