I'm trying to create a macro. I am referencing cell A1 in 'Sheet2' to cell
A20 in 'Sheet1'. How do I make the Active Cell A1 in 'Sheet1'??? Thanks

~Justin

Hi,

You do that by selecting it

Sheets("Sheet1").Range("A1").Select

But it's very unlikely you need to do that. Selecting slows things down and
more often than not isn't necessary.

Mike

"soldier1981" wrote:

I'm trying to create a macro. I am referencing cell A1 in 'Sheet2' to cell
A20 in 'Sheet1'. How do I make the Active Cell A1 in 'Sheet1'??? Thanks

~Justin

As Mike said, it is very unlikely you need to select anything. If you would
describe what you are trying to do in more detail (include your current
relevant code, working or not), I think we can show you code that does not
use Selections at all.

In the meantime, perhaps this previous posting of mine (a response to
another person using Select/Selection type constructions) will be of some
help
to you in your future programming...
Whenever you see code constructed like this...

Range("A1").Select
Selection.<whatever

you can almost always do this instead...

Range("A1").<whatever

In your particular case, you have this...

Range("C2:C8193").Select 'select cells to export
For Each r In Selection.Rows

which, using the above concept, can be reduced to this...

For Each r In Range("C2:C8193").Rows

Notice, all I have done is replace Selection with the range you Select(ed)
in the previous statement and eliminate the process of
doing any Select(ion)s. Stated another way, the Selection produced from
Range(...).Select is a range and, of course, Range(...) is a
range... and, in fact, they are the same range, so it doesn't matter which
one you use. The added benefit of not selecting ranges
first is your active cell does not change.

--
Rick (MVP - Excel)


"soldier1981" wrote in message
...
I'm trying to create a macro. I am referencing cell A1 in 'Sheet2' to
cell
A20 in 'Sheet1'. How do I make the Active Cell A1 in 'Sheet1'??? Thanks

~Justin