ROUNDing on a MAC - conversion error

[Lokai]

ROUNDing on a MAC - error

If Round(c, 2) <> c Then c.Value = Round(c.Value, 2)

The macro above works fine in Windows but is hanging on a Macintosh.

Specifically I get an error "Compile Error: Sub or Function no
defined" when I use this Round function on a Mac - it thinks Round(x,2
is calling a sub or function.

Is there a way around this? (no pun intended)
I don't have easy access to Mac for testing.

(I did post at mrexcel but it has dropped to the 4th page with n
response

 

[Mike Middleton]

Lokai -

Current versions of Windows Excel have a newer version of VBA than current
versions of Mac Excel.

The current versions of Mac Excel do not have a VBA Round function.

Perhaps you could use application.worksheetfunction.round so that it will
work on both platforms.

If you need further advice about Mac issues, you may want to try the
microsoft.public.mac.office.excel newsgroup.

- Mike
www.mikemiddleton.com

 

[Lokai]

Thank you Mike, that did the trick