stuck with activecell offset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

D Pingger - 21 Mar 2006 23:40 GMT

"ActiveCell.Offset(6, 96).Copy" This gets me to where I want to copy
a cell

but "ActiveCell.Offset(-6, -96).Select" doesn't take me back to the
previous cell.

What am I missing?!?!
TIA!!!

Pingger

Reply to this Message

Chip Pearson - 21 Mar 2006 23:44 GMT

Pingger,

The line of code
ActiveCell.Offset(6, 96).Copy

doesn't move the active cell.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

> "ActiveCell.Offset(6, 96).Copy" This gets me to where I
> want to copy
[quoted text clipped - 8 lines]
>
> Pingger

Reply to this Message

D Pingger - 21 Mar 2006 23:56 GMT

That's good to know, Chip. Thanks.

But how do I go to the left and up if "ActiveCell.Offset(-X, -Y).Select"
doesn't work?

TIA

pingger

> Pingger,
>
[quoted text clipped - 15 lines]
> >
> > Pingger

Reply to this Message

Chip Pearson - 22 Mar 2006 00:16 GMT

> But how do I go to the left and up if
> "ActiveCell.Offset(-X, -Y).Select"
> doesn't work?

You can go up and to the left with the code you have. You just
make sure you don't attempt to go off the sheet.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

> That's good to know, Chip. Thanks.
>
[quoted text clipped - 27 lines]
>> >
>> > Pingger

Reply to this Message

D Pingger - 22 Mar 2006 00:27 GMT

I got it now, Chip. It's working again.

Thanks a lot.

Pingger

> That's good to know, Chip. Thanks.
>
[quoted text clipped - 24 lines]
> > >
> > > Pingger

Reply to this Message