VBA's round was added in xl2k.

You can use application.round in xl97, but be aware that they do slightly
different things:

http://support.microsoft.com/default...;en-us;q225330
OFF2000: New Round Function in Visual Basic for Applications 6.0

Marcus wrote:

Hi all

i took an excel sheet home to have a quick look at from work, however it
breaks on this line on my home comp :

totalpercent(7) = Round((totaldelay(7) / totalday) * 100, 2)

it highlights the word Round and says sub or function not defined,
seeing as i am only running the maco i have not changed anything.

any ideas ?

Thanks!

Oh i use win98 excel 2002 at work, at home where prob is i use win98 excel
97 if that helps.

Cheers!

--

Dave Peterson