Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel
Message
 
To
30/07/1998 10:56:07
Travis Clark
Journal Record Publishing Co
Oklahoma City, Oklahoma, United States
General information
Forum:
Visual Basic
Category:
VBA
Title:
Re: Excel
Miscellaneous
Thread ID:
00122693
Message ID:
00122853
Views:
13
>I am desperately trying to figure out how to activate a cell that is in one row up from my present 'ActiveCell.'
>Recording a macro doesn't work, because it specifies the cell by range. I need a general, all-purpose way of activating and pasting into one cell above the present cell.
>Anyone have any ideas?
>
>Thanks
>Travis

I think what you want is
ActiveCell.Offset(RowOffset, ColumnOffset).activate

ActiveCell.Offset(-1, 0).Activate

HTH
Jeff

It's Time to get a gun.

That's what I've been thinkin.

I think I can afford one, If I do a little less Drinkin.

www.TrueGeeks.com
Previous
Reply
Map
View

Click here to load this message in the networking platform