ReplaceFormat

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neil - 28 Jan 2008 08:29 GMT

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?

Reply to this Message

Bob Greenblatt - 28 Jan 2008 16:34 GMT

On 1/28/08 3:29 AM, in article
9a6ed35d-745b-461d-8c9c-e22bde058f35@e6g2000prf.googlegroups.com, "Neil"
<neilmeehan@gmail.com> wrote:

> 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
[quoted text clipped - 5 lines]
> 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.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Neil - 29 Jan 2008 07:12 GMT

> On 1/28/08 3:29 AM, in article
> 9a6ed35d-745b-461d-8c9c-e22bde058...@e6g2000prf.googlegroups.com, "Neil"
[quoted text clipped - 18 lines]
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

Thanks, so Im not crazy!

Reply to this Message

Mac Forum / Applications / Excel / January 2008

ReplaceFormat