Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple ? problem with value or/of formula ?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with a simple formula | Excel Discussion (Misc queries) | |||
Having problem with 'if' in what should be a simple formula | Excel Worksheet Functions | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
simple formula problem | Excel Discussion (Misc queries) | |||
Simple (?) Formula Problem | Excel Programming |