>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