Hello,
how can I write code for. if is active cell is in range (variable) of cells, can run macro
for i=9 to 286
if cells(i,56)>1000 then
if activecell= Range(Cells(i + 1, 5), Cells(i + 1, 35)) Then
call macro
end if
end if
next i
if Active cell is in the row and collum i+1 and collum 5 to 35, then I can call macro.
if this is not this row, macro must not be run...
please for help
Regadrs
Borut
[/COLOR]
