Thread
:
Offset the result
View Single Post
#
2
Posted to microsoft.public.excel.programming
Mike H
external usenet poster
Posts: 11,501
Offset the result
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 Quote
Mike H
View Public Profile
Find all posts by Mike H