Thread: Acivecell.Formula Offset End(xlUp)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] transferxxx@gmail.com is offline
external usenet poster
  
Posts: 31
Default 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

Reply With QuoteReply With Quote