-
Solved: MROUND Function
Hey all,
So im using MROUND to round a number to the nearest .125". Works fine but the problem is all users need to load the analysis tool pack for it to work.
Is there anyway to use VBA to enable the tool pack if it isnt aready enabled?
or I guess this will work
=ROUND(Q17*8,0)/8
thanks mucho grande
-
Try putting
[VBA]Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
End sub[/VBA]
in the Workbook_Open module.
HTH.
Lincoln
-
Ahh very nice!
works perfect
thanks much
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules