Macro Range Selection

[Roy A.]

Range("A16:C16").Select

I would like the above command to select columns A:C with the current cursor
row.

Obviously a Macro newbee, lol Thanks for any assistance.

 

[FSt1]

hi
range("A:C").select would select columns A through C but what is the
"current cursor row"?

regards
FSt1

 

[Mike H]

maybe

Union(ActiveCell.EntireRow, Range("A:C")).Select

Mike

 

[Mika Oukka]

This one selects cells from A to C on activecells row:

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

Mika Oukka, IT-Consultant

 

[Dave Peterson]

I bet you meant

intersect(activecell.entirerow, range("a:c"))

 

[Dave Peterson]

One more:
activecell.entirerow.cells(1).resize(1,3).select

 

[Mike H]

I did <g> thanks

I bet you meant

intersect(activecell.entirerow, range("a:c"))

 

[Dave Peterson]

Another one:
activecell.entirerow.cells(1).range("a1:C1").select
or
activecell.entirerow.range("a1:C1").select

(I kind of like the documentation that .cells(1) provides.)