LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to activate the cell in same row, column 1?

I want to write a macro that moves the active cell to the same row but
column 1, then does some stuff, and then exits leaving the active cell
in column 1 on the next row.

I have the "stuff" working but the user must select the cell in column 1
before invoking the macro. I would like to remove that requirement. So I
have to activate (or select? or what?) the cell in column 1 no matter
what column I am in now. How do I do that?
 
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
activate cell varun Excel Worksheet Functions 1 February 5th 09 08:18 AM
activate column of URLs as hyperlinks [email protected] Excel Discussion (Misc queries) 3 November 7th 05 09:03 PM
Activate Cell Brett Excel Discussion (Misc queries) 2 March 29th 05 06:20 PM
Activate email column to hyperlinks DixieWins Excel Discussion (Misc queries) 2 February 3rd 05 08:09 PM
Activate Column after locating text in a row Smythe32 Excel Programming 1 July 17th 03 05:32 PM


All times are GMT +1. The time now is 09:24 PM.

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

About Us

"It's about Microsoft Excel"