I am trying to write a VBA macro that scans down a column and when
value is lower in cell before and lower in cell after (i.e. at a peak
and a variable is set at specific value that information is then copie
onto another spread sheet.

In old spreadsheet system I used I could put
IF r2c2<r1c2 AND r3c2<r2c2 AND x=yes THEN
"tell it what to do"
END IF

Is there a way in VBA to use AND in an IF...END IF statement?
Or should I be using some other formula

--
Message posted from http://www.ExcelForum.com

Hi
something like
if range("B2").value<range("B1").value and _
x="yes" then
'do something
end if

--
Regards
Frank Kabel
Frankfurt, Germany


I am trying to write a VBA macro that scans down a column and when a
value is lower in cell before and lower in cell after (i.e. at a
peak)
and a variable is set at specific value that information is then
copied onto another spread sheet.

In old spreadsheet system I used I could put
IF r2c2<r1c2 AND r3c2<r2c2 AND x=yes THEN
"tell it what to do"
END IF

Is there a way in VBA to use AND in an IF...END IF statement?
Or should I be using some other formula?


---
Message posted from http://www.ExcelForum.com/