Hmmm.. If you're using Office 2003 on your Mac (not MAC), then you're
running it in a Windows version (i.e., via Parallels or virtual machine
or BootCamp), so it should compile.

If you actually are trying to compile it in Office 2004 (the Mac
version) instead, Mac VBA is at version 5, which doesn't include the
Round() function. Either supply your own or use Application.Round (note
however, that the XL function handles a 5 in the terminal digit
differently than the VBA function does:

=ROUND(0.5, 0) == 1

?Round(0.5, 0) == 0






In article ,
sross002 wrote:

I have office 2003