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