Change #VALUE! fields in a column

  • Column A has about 1,600 rows of data. The fields are either a number (such as 45355) or #VALUE!


    I'd like to create a macro that changes every #VALUE! field to the nearest number above.


    For example:


    45355
    #VALUE!
    #VALUE!
    12345
    #VALUE!
    #VALUE!
    #VALUE!


    Should become:


    45355
    45355
    45355
    12345
    12345
    12345
    12345


    Can anyone help me with how I would create a macro to do this please?

  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!