ROUND in VBA--SOLVED via JPG

[just_jon]

Hello, again, everybody -- as usual, I need some expert advice. Does anyone know why the line below might cause an error -- compile error Sub or Function not defined ?

Sbt = Round(.Cells(40, 9), 2)

Not having all versions of XL, I don't know if Application.WorksheetFunction. in front of it would cure the problem.

Thanks to all,
Jon

 

[Juan Pablo González]

Re: ROUND in VBA

Yes, put the WorksheetFunction in front... VBA's Round wasn't avaiable in 97.

 

[just_jon]

Thank you Juan; had a feeling that might have been it.

Regards,
Jon