Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I use
Private Sub Worksheet_Change(ByVal Target As Range) og a cell containing a formula, Target.Formula is the Formula after the change has happened. Is there any way to get the Formula that is in the cell BEFORE the change happens? I cannot use Private Sub Worksheet_SelectionChange(ByVal Target As Range) to grab the formula, as the user is not necessarilu selecting the cell before the change. Regards Jan |