Thread: ActiveCell.Row & Column intersect
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default ActiveCell.Row & Column intersect
Try this

Cells(ActiveCell.Row, "G").Select

Or

Cells(ActiveCell.Row, 7).Select


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ups.com...
I'm am trying to refer to the cell where the ActiveCell.Row and
Column(7) intersect. Any help would be greatly appreciated. Thanks

Reply With QuoteReply With Quote