Excel for mac vba to clear a range

broken image
broken image

In any case, the code on line 8 is the first line of code in the module, just declaring a string variable:Īnd I've placed the full code below (two subroutines contained in the same module). At first I thought there could be a missing library reference or something, but I think the error message would state such instead of just being a compile error, no? So the module is obviously called 'modPanda' and I think the '8:4' references screen coordinates for the offending code (line 8 column 4). Here is what the error message on their Mac says:Ĭompile Error: User-defined type not defined (modPanda 8:4) I've Googled this quite a bit and can't seem to figure it out. Don't have a Mac myself to test on, which doesn't help.

broken image

So I've written a routine for customers, and those with Macs are not able to run it.