By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,557 Members | 1,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,557 IT Pros & Developers. It's quick & easy.

VBA Excel Help - I need an cell placeholder

P: 7
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
Share this Question
Share on Google+
1 Reply


100+
P: 267
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.