View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lokai Lokai is offline
external usenet poster
 
Posts: 1
Default ROUNDing on a MAC - conversion error


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

--
Loka
-----------------------------------------------------------------------
Lokai's Profile: http://www.excelforum.com/member.php...fo&userid=2479
View this thread: http://www.excelforum.com/showthread.php?threadid=38358