Thread: how do I select cells in column A thru F in the active row?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rowan[_2_] Rowan[_2_] is offline
external usenet poster
  
Posts: 226
Default how do I select cells in column A thru F in the active row?
One way:

Range(Cells(ActiveCell.Row, 1), Cells(ActiveCell.Row, 6)).Select

Regards
Rowan

"jonco" wrote:

What I'm tring to do is select cells in column A thru F in whatever row is
active no matter what cell in what column is active.

I know it's simple but I forgot how to do it. Thanks
Jon



Reply With QuoteReply With Quote