08-05-2010, 02:00 PM
insert after es.GetCells...
or
Macro Excel get row
The second code does not erase Undo.
;make selected cells green
Excel.Range sr=es.ws.Application.Selection
sr.Interior.ColorIndex = 4
sr.Interior.Pattern = Excel.xlSolidor
Macro Excel get row
Acc ac=acc("Fill Color" "DROPLIST" win("" "XLMAIN") "MsoCommandBar" "" 0x1001)
ac.Mouse(1)The second code does not erase Undo.
