I've been working on a macro for a few days now and I've gotten to
part that is over my head. I'm trying to code the following:

For Each cell in Column G that has data in it (Calling this G# below)
- If Cell(G#) = (Condition1 AND Condition2) OR (Condition3 AN
Condition4) THEN
--- Select all remaining cells in worksheet (including current row
except those cells in Column A
--- Multiply the numbers in all selected cells by ratio o
Cell(G#)/Cell(G#-1)
- Else Continue Next Cell (G#+1)
- End If

So far, I've figured out how to code the part about "selecting al
remaining cells in the worksheet except those cells in column A" wit
the following code:

Range(Selection, Selection.End(xlToLeft)).Offset(0, 1).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select

Can anyone offer any clues about how the rest of this is coded in vba?

Thank

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