Acivecell.Formula Offset End(xlUp)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

transferxxx@gmail.com - 21 Mar 2006 12:33 GMT

How can i convert the macro below to Acivecell.Formula = ??? i.e get
the cell reference of the resulting cell.

Sub activece()
ActiveCell.Value = ActiveCell.Offset(0, -1).End(xlUp)
End Sub

Thxs

Reply to this Message

Martin - 21 Mar 2006 12:45 GMT

Stick .Address at the end

> How can i convert the macro below to Acivecell.Formula = ??? i.e get
> the cell reference of the resulting cell.
[quoted text clipped - 4 lines]
>
> Thxs

Reply to this Message

christopher.lepingwell@gs.com - 21 Mar 2006 13:02 GMT

Try this:

Sub activece()
ActiveCell.Value = ActiveCell.Offset(0, -1).End(xlUp).Address
End Sub

Reply to this Message

Tom Ogilvy - 21 Mar 2006 13:40 GMT

Sub activece()
ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).End(xlUp).Address
End Sub

Signature

Regards,
Tom Ogilvy

> How can i convert the macro below to Acivecell.Formula = ??? i.e get
> the cell reference of the resulting cell.
[quoted text clipped - 4 lines]
>
> Thxs

Reply to this Message