Hi. I'm very new to VBA & macros... just a beginner!
I wish for my VBA procedure to affect my currently selected cells (one or more), wherever they may be.
The selected cells may already contain various values... example: 88.12345 and 99.54321.
For each cell selected, I'd like to take those starting values and wrap them in a 2-decimal 'round' formula... example: =round(88.12345,2) and =round(99.54321,2). Any selected cells that were blank before running my VBA should remain blank after.
Here's what I've got so far... obviously, it's not working:
Above... i've tried breaking the 'round' formula into two halves and declared each half a string (RoundA and RoundB)... and then inserting the current cell value between the two strings of the formula... and then reinserting the whole new formula (RoundA + initial cell value + RoundB) back into the selected cell.
Not clear which to use - activecell.formula vs activecell.value - in this instance; hence, using ' to keep one as a placeholder for the time being.
Anyways, if someone could please tell me the error or my ways, and set me straight on how to accomplish what I want, I'd be very grateful.
Thank you so much!
Bookmarks