Save A Cell Location

[nebb]

If, In a macro, a desired cell is located , how can I go about saving the location of that cell to be used later in the macro?

[mikerickson]

The easiest way is to use a range variable.

Please Login or Register  to view this content.

The Dim statement can be put anytime before the second line. Most folks put all their declarations at the start of the Macro.
Anytime later, in the same macro (see Help system "scope"), myRange will refer to the stored value as in:

Please Login or Register  to view this content.

Note that myRange is a Range object. It refers to the cell, NOT to the value in the cell.
To refer to the value in the cell, use

Please Login or Register  to view this content.

.
If the cell contains a formula,

Please Login or Register  to view this content.

refers to the value in the cell. If you want the formula (as a string) use

Please Login or Register  to view this content.

It sounds like you are new to programming in VB. Selecting is seldom needed. The Macro recorder uses it frequently, but it can ususally be ommited. For example

Please Login or Register  to view this content.

will set myRange to [myBook]Sheet 1!A1:B4 without selecting.

[nebb]

That was exactly what I needed. Thanks Mikerickson.

[mikerickson]

You're welcome