Macro Required

  • Hello
    I am working on a large data of 18,000 rows 8 columns and as you know that saving or auto filter takes lot of time for such type of data. So someone can help me to fill Empty cells automatically with the 0 value or "-" through macro or any other method so that the speed of functions may be increased little bit.
    Nabeel

  • Hi Nabeel,


    I'm not sure how filling empty cells with 0 or - values will speed up either saving or filtering your data.


    If any of the values in your list are created using formulas, it may speed up filtering if you turn off automatic calculation before filtering.


    Hope this helps.


    Regards,
    Batman.

    [COLOR="Purple"]Regards,[/COLOR]
    [COLOR="Purple"]Batman.[/COLOR]

Participate now!

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