Hi,
I made the following code, i want to check the values of 2 colums
when column 27 colum 26 a macro will be started
it works oke when i use typed in values
BUT when i put formulas in both colums i.g "=B25" or so
then i wont work, who has some help

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 26 Then Exit Sub
If Target.Column 27 Then Exit Sub

(there is something wrong in the next line, when using formulas in th
sheet)
If Cells(Target.Row, 27) Cells(Target.Row, 26) Then

macro

End If

End Su

--
pim_parr
-----------------------------------------------------------------------
pim_parra's Profile: http://www.msusenet.com/member.php?userid=41
View this thread: http://www.msusenet.com/t-186940767