| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stuck with activecell offset
"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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stuck with activecell offset
Pingger,
The line of code ActiveCell.Offset(6, 96).Copy doesn't move the active cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "D Pingger" wrote in message ... "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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stuck with activecell offset
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 "Chip Pearson" wrote: Pingger, The line of code ActiveCell.Offset(6, 96).Copy doesn't move the active cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "D Pingger" wrote in message ... "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stuck with activecell offset
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. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "D Pingger" wrote in message ... 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 "Chip Pearson" wrote: Pingger, The line of code ActiveCell.Offset(6, 96).Copy doesn't move the active cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "D Pingger" wrote in message ... "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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stuck with activecell offset
I got it now, Chip. It's working again.
Thanks a lot. Pingger "D Pingger" wrote: 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 "Chip Pearson" wrote: Pingger, The line of code ActiveCell.Offset(6, 96).Copy doesn't move the active cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "D Pingger" wrote in message ... "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| ActiveCell Offset | Excel Programming | |||
| Activecell Offset | Excel Programming | |||
| ActiveCell.Offset w/ VBA | Excel Programming | |||
| activecell offset | Excel Programming | |||
Linear Mode
