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: 70
Default Make active cell a variable, return there later

User selects a cell and then hits a hot key to run a macro. I need the macro
to note that cell range, do some manipulations, then return to that cell and
run some offset copy/pastes from there. The offset part works fine, but in
the process of the first manipulations we're failing to return to the
original cell to then run the offsets from there. I figure if I set a
variable for the original cell, then I can return to that cell after the
first manipulations. But I don't know how to set a variable for the active
cell range, and don't know how to later return to (activate/select) the range
of the variable.
 
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
Set a variable to the active cell Richard Excel Discussion (Misc queries) 1 March 24th 08 05:42 PM
How to set active cell range to an variable Jørgen Andreassen Excel Programming 4 August 20th 07 02:37 PM
Return to active cell Alex.W Excel Discussion (Misc queries) 2 June 19th 07 11:35 PM
name variable with 3 first characters of active cell shark102 Excel Programming 6 October 22nd 05 02:32 AM
value of active cell into a variable TusaJii Excel Programming 1 January 24th 04 05:54 PM


All times are GMT +1. The time now is 07:07 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"