ActiveCell.Row & Column intersect
 

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

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

ActiveCell.Row & Column intersect
 

That did the trick. Thanks Ron