Acivecell.Formula Offset End(xlUp)
 

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

Acivecell.Formula Offset End(xlUp)
 

Stick .Address at the end

" wrote:

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

Acivecell.Formula Offset End(xlUp)
 

Try this:

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

Acivecell.Formula Offset End(xlUp)
 

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


--
Regards,
Tom Ogilvy

" wrote:

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