I need to use the mround function on an entire spreadsheet without messing up the data. I
I need to use the mround function on an entire spreadsheet without messing up the data. I
I guess you would have to modify each occupied cell in the worksheet.
So you would need to use a macro.
The macro would select every numerical cell. which is easy to do if you use the select special function.
You would then wrap your mround function around the cell formula. ( deleting the existing "=" sign first )
Is that what you need?
Looks like you hit "Post" before you completed your question?
Maybe use a helper sheet and apply the mround that way?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks