Posts by mdeavila

    Hi, I am having the same exact issue as the OP. I figured out a code to spit out the correct number of sig figs in every cell when running the macro, my issue is with numbers below 100, where the rounding is effective but the display numbers are not rounded to 3 sig figs effectively.

    Curious if anyone has figured out a solution to this issue?

    These pretty much dictate the significant figure and rounding calculations to be used:

    Hi MD,

    Your code literally says to stop when you get to a blank cell, just redefine the end point somehow. Eg do until activecell.row = 1000 or wherever your last table row is likely to be.

    I literally copied this code from another sheet that had a similar code to what I needed to apply. if I redefine the activecell - would the code be changed to this?

    Do Until ActiveCell.Row = "1000"

    I'm literally a novice to this. I appreciate everyone's help!

    How would I best apply a code to allow the macro to modify my data without stopping in areas where there is a space?

    The code above has worked very well, except in instances where there is an empty cell, it does not continue to the next cell without selecting the areas again. This is rather inconvenient as I often have data sets separated by an empty cell.

    thanks in advance

    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.Offset(1, 0).Select
    End Sub

    Thanks in advance!

    Moderator Note: I have added code tags for you. Please read the forum rules you agreed to abide by.