Thread: Offset the result
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Offset the result
OOPS,

that should have been

Range("L1").Value = ActiveCell.Offset(-1) + 50

Mike

"Mike H" wrote:

Hi,

With L5 as the active cell try this

Range("L1").Value = ActiveCell.Offset(, -1) + 50

Mike

"Jock" wrote:

If cell L5 has focus, can call L1 display the contents of L4 + 50?
--
Traa Dy Liooar

Jock
Reply With QuoteReply With Quote