Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 97
Default How to programmatically make a cell the Active Cell?

Is that possible?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default How to programmatically make a cell the Active Cell?

the active cell IS the activecell

x=activecell.row
y=activecell.column
z=activecell.address
activecell.offset(1,6)
etc, etc.
--
Don Guillett
SalesAid Software

"Jack" <replyto@newsgroup wrote in message
...
Is that possible?




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 97
Default How to programmatically make a cell the Active Cell?

Maybe it was not clearly said.
I need to make another cell to become ActiveCell without clicking on it but
to be done programmatically.
How to do that?

"Don Guillett" wrote in message
...
the active cell IS the activecell

x=activecell.row
y=activecell.column
z=activecell.address
activecell.offset(1,6)
etc, etc.
--
Don Guillett
SalesAid Software

"Jack" <replyto@newsgroup wrote in message
...
Is that possible?






  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 97
Default How to programmatically make a cell the Active Cell?

Thank you. That is what I need. :)

"Jack" <replyto@newsgroup wrote in message
...
Is that possible?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make identical cell datas active to allow changes caprey New Users to Excel 5 December 21st 08 05:42 PM
how do i make a chart follow the active cell mepetey Charts and Charting in Excel 2 October 20th 07 07:29 PM
I HAVE SAY INFO ACROSS 10 COLUMNS. HOW TO MAKE THE COL-A CELL ACTIVE WHEN U HIT 'ENTER' CAPTGNVR Excel Discussion (Misc queries) 4 February 5th 07 08:27 PM
How do I make it so that the active cell follows the cursor keys? jmitchener Excel Discussion (Misc queries) 2 September 10th 06 06:07 PM
Make a particular cell the active one Newbie Excel Programming 3 April 14th 04 04:52 PM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"