macro fror 2004 not working in 2011 for mac

[Butehawk]

I have a macro that I use in 2004 and it will not run in 2011 for mac. Does anybody know if there are differences in the code used. Just to be straight about this my other macros work in 2011.

Please Login or Register  to view this content.

When I try to run it it turns red from line starting "Range" to "Replace What:="$3".

[romperstomper]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[shg]

I don't have a Mac, but I'd code the one line as

Please Login or Register  to view this content.

[romperstomper]

The second line of your Range statement starts with curly quotation marks - you need to replace that with normal ones - i.e

Please Login or Register  to view this content.

needs to be:

Please Login or Register  to view this content.

then your code is fine in 2011 (and other versions).

[Butehawk]

Thanks for that but it now stops at "searchformat" with the error as "named argument not found. Any Ideas.

[romperstomper]

Ah, I should have tried running it rather than just compiling it. You can't use SearchFormat or ReplaceFormat as they aren't valid arguments in the new Mac VBA.

[Butehawk]

Thanks Romper,
That has fixed it. Is there a book on mac VBA that you could recommend? I am new to this.

[romperstomper]

I don't know of any Mac-specific VBA books to be honest. In prior versions of MacOffice, it was basically VBA5 with a few limitations and differences due to the platform. 2011 is supposed to be more akin to VBA6, but there are obviously some differences.

[Butehawk]

Thanks again.