LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default How do I get the content of the cell left of the active cell?

ActiveCell.Offset(0, -1).Value
--
Gary's Student


"TimK" wrote:

I want to drive the execution of my macro based on the user's entry into the
cell adjacent to the left of the current cell. How do I get the content of
that cell? I see several ways of getting the current cell's content, but
nothing on how to move relative to the current cell.

 
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
macro to find cell content in sheets and make sheet active Nigel Excel Discussion (Misc queries) 4 June 26th 14 02:38 PM
referring to formula in a non active cell from active cell nickname Excel Discussion (Misc queries) 1 June 21st 07 12:11 PM
Moving left/right from active cell Kurt Barr[_2_] Excel Programming 3 January 4th 06 05:30 PM
Moving the Active cell to the left of the screen Dave Bash Excel Programming 1 December 17th 03 04:11 PM
Setting bkcolor on active cell when left mouse doubleclikked Jan Eikeland Excel Programming 3 December 12th 03 12:45 PM


All times are GMT +1. The time now is 12:00 AM.

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"