ReplaceFormat

[Neil]

Im trying to migrate an excel workbook from pc to mac. I have some VBA
in the back ground so when I double click on a cell, the macro will
search through a region and reformat all the cells matching the value
of the "double-clicked" cell to a new color. The problem is on the
Mac, the "Application.ReplaceFormat" method causes an error. In fact
when I look at the menus on in excel (on the mac) I can't seem to find
the "format color" option in the "find and replace" menu. Is there a
work around for this? Does "Application.ReplaceFormat" not exist on
the mac version of excel?

 

[Bob Greenblatt]

Im trying to migrate an excel workbook from pc to mac. I have some VBA
in the back ground so when I double click on a cell, the macro will
search through a region and reformat all the cells matching the value
of the "double-clicked" cell to a new color. The problem is on the
Mac, the "Application.ReplaceFormat" method causes an error. In fact
when I look at the menus on in excel (on the mac) I can't seem to find
the "format color" option in the "find and replace" menu. Is there a
work around for this? Does "Application.ReplaceFormat" not exist on
the mac version of excel?

Correct. Application.Replaceformat does not exist in Macintosh VBA. To get
this to work on the Mac, you'll have to do this a different way, like
storing the active cell's format attributes and then applying them to the
range.

 

[Neil]

Correct. Application.Replaceformat does not exist in Macintosh VBA. To get
this to work on the Mac, you'll have to do this a different way, like
storing the active cell's format attributes and then applying them to the
range.

Thanks, so Im not crazy!