Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel
Message
 
À
30/07/1998 10:56:07
Travis Clark
Journal Record Publishing Co
Oklahoma City, Oklahoma, États-Unis
Information générale
Forum:
Visual Basic
Catégorie:
VBA
Titre:
Re: Excel
Divers
Thread ID:
00122693
Message ID:
00122853
Vues:
12
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform