I created a macro to round values in a spreadsheet to 3 sig digits, but I am struggling in getting the code to format values that are past an empty cell - it stops right at the empty cell, but I want this macro to be applied to all the values on a sheet and move to the next cell after an empty cell.
I could only figure out how to apply it to rows and columns so I created two pieces to it (which isn't a big deal for me).
I don't have a lot of experience here, but any help is much appreciated!
Here is my code:
Do Until ActiveCell.Value = "" ActiveCell.Select Format_Sig_Figs Round_Calc ActiveCell.Offset(1, 0).Select Loop End Sub
Thanks in advance!
Moderator Note: I have added code tags for you. Please read the forum rules you agreed to abide by.