This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
billa,
This method is used only for changing a single cell color, however you can change back color by of multiple cells using loops. try this code:
for i=1 to 3 ' for rows
for j= 1 to 3 'for cols
mf1.row=i
mf1.col=j
mf1.cellbackcolor=vbred
next
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=431094&SiteId=1