467,879 Members | 1,087 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,879 developers. It's quick & easy.

VBA Excel Help - I need an cell placeholder

I searched - sorry if this is posted incorrectly.

So I'm working on a project that involves the need to go back and forth between two separate locations within the spreadsheet, both of which are relative positions which the program will need to search through the data to find.

So I know how to get to each individually to start, but I don't know how to jump back and forth in location. Hypothetically it should be as easy as:

holder = ActiveCell.Address

' find other spot, work on it, and then try to return to first spot with:

ActiveCell.Address = holder

I get errors despite several changes to the variable type (object, varient, range) and what I'm setting it to (ActiveCell.Location, ActiveCell, ActiveCell.Address).

Can anyone help me create a variable and properly set it to not only record an address, but manage to set the focus back to that address after some other code? Thank you so much.
Nov 16 '06 #1
  • viewed: 3533
Share:
1 Reply
100+
I searched - sorry if this is posted incorrectly.

So I'm working on a project that involves the need to go back and forth between two separate locations within the spreadsheet, both of which are relative positions which the program will need to search through the data to find.

So I know how to get to each individually to start, but I don't know how to jump back and forth in location. Hypothetically it should be as easy as:

holder = ActiveCell.Address

' find other spot, work on it, and then try to return to first spot with:

ActiveCell.Address = holder

I get errors despite several changes to the variable type (object, varient, range) and what I'm setting it to (ActiveCell.Location, ActiveCell, ActiveCell.Address).

Can anyone help me create a variable and properly set it to not only record an address, but manage to set the focus back to that address after some other code? Thank you so much.
hi

use
Range(Holder).Select
Nov 16 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
3 posts views Thread by Otie | last post: by
6 posts views Thread by Matthew Wieder | last post: by
18 posts views Thread by Frank M. Walter | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.