PC Review


Reply
Thread Tools Rate Thread

ActiveCell.Row & Column intersect

 
 
kylekelsch@hotmail.com
Guest
Posts: n/a
 
      2nd Mar 2007
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 Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      2nd Mar 2007
Try this

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

Or

Cells(ActiveCell.Row, 7).Select


--

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


<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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 Quote
 
kylekelsch@hotmail.com
Guest
Posts: n/a
 
      2nd Mar 2007
That did the trick. Thanks Ron

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Set ActiveCell at the first column of the same row... Dave Microsoft Excel Misc 0 16th Apr 2009 08:03 PM
If activecell.column = variable then activecell,offset (0,1) Battykoda via OfficeKB.com Microsoft Excel Misc 1 2nd Oct 2007 08:05 PM
Select cell where column and row intersect. ExcelTricks@gmail.com Microsoft Excel Programming 6 3rd Dec 2006 08:01 PM
Row column intersect thiaga Microsoft Excel Programming 0 4th Apr 2006 06:32 PM
How do I find where a column value and row value intersect? =?Utf-8?B?QW15?= Microsoft Excel Worksheet Functions 2 12th Jan 2005 11:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:56 PM.