ActiveSheet.Columns(ActiveCell.Column).Rows(3).Select ---- I'm trying to select multiple rows (cells) in the active column.

[healeydm]

I'm trying to select specific rows in the active column - I've found the above code to work, but I need to be able to select rows 3, 10, 20. I've tried a few different codes for this, but all of them have selected the entire row and not just the row number in the active column.

ActiveSheet.Columns(ActiveCell.Column).Rows(3).Select

 

[jolivanes]

Am I not understanding your requirements right? If you select entire rows, what do the column selection have to do with it?

Re: "row number in the active column"
Do you mean to select only the cells in that particular Column, not the whole Rows?

 

[healeydm]

Am I not understanding your requirements right? If you select entire rows, what do the column selection have to do with it?

My column range is dynamic, and I'm trying to select the specific cells in the active column. For example, if my active column is M I'd need M3, M10, and M20. Sorry, I'm trying to figure out the best way to explain it.

 

[jolivanes]

Select a cell in the Column in question and run this snippet.

Sub Maybe_So()
Dim rwRng As Range, curCol As Long
curCol = ActiveCell.Column
    Set rwRng = Union(Cells(3, curCol), Cells(10, curCol), Cells(20, curCol))
rwRng.Select
End Sub

 

[jolivanes]

Another (shorter) possibility

Sub Thanks_To_Fluff()
    Intersect(Columns(ActiveCell.Column), Range("3:3,10:10,20:20")).Select
End Sub

 

[healeydm]

Select a cell in the Column in question and run this snippet.

Sub Maybe_So()
Dim rwRng As Range, curCol As Long
curCol = ActiveCell.Column
    Set rwRng = Union(Cells(3, curCol), Cells(10, curCol), Cells(20, curCol))
rwRng.Select
End Sub

This worked great, thank you so much!!

 

[jolivanes]

Thank you for the update and good luck. You even have a spare solution to try.