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

Hi,
It works for me.

If I put a formula in , say =B25 (in a row in col 26) and =A34 (in the
corresponding row in col 27), then if A34=20 and b25 = 5 then mcro will
execute as col 26=5 and col 27=20.

The formulas e.g = B25 will be evaluated to a number or text. Check the
formulas give sensible results i.e. comparing numbers with numbers.

Can you give an example of your data?


HTH

MS 2003

"pim_parra" wrote:


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 the
sheet)
If Cells(Target.Row, 27) Cells(Target.Row, 26) Then

macro

End If

End Sub


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