I am generating random numbers within VBA that I would like to round up to the next whole number. I'm not using the worksheet. I would like to do this within the code. A solution is appreciated.
I am generating random numbers within VBA that I would like to round up to the next whole number. I'm not using the worksheet. I would like to do this within the code. A solution is appreciated.
Hi, Siegfried,
you may use WorksheetFunction.RoundUp to round the random numbers or maybe even use WorksheetFunction.RandBetween for doing so.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger, That works like a charm. Thank you so much.
I am from Hamburg many years ago and have a cousin named Holger living in Hamburg. You're not my cousin are you? I visited my old neighborhood in Altona last year.
Siegfried
Last edited by Siegfried; 05-15-2013 at 01:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks