Results 1 to 2 of 2

Thread: Analysis of adding a extra row to a model with lot of macros.

  1. #1

    Analysis of adding a extra row to a model with lot of macros.

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have recently started working on a model built by some one else and I need to add a extra row to model. The Model has lot of macros on every page. So i need to know how adding an extra row is going to affect the macros.

    I don't know much about macros.

    1) Please suggest how to go ahead.
    2) Also suggest what are basic things to be kept in mind when performing such an analysis.

    I understand the main problem would be that the references in the macro wont get updated which might lead the macro to malfunction.

    Whats the best way to analyze which macros are getting effected.

  2. #2
    Acolyte Charles's Avatar
    Join Date
    Feb 2013
    Excel Version
    Mac Excel 2011

    Unless I'm wrong without seeing the macro and how it affect the worksheet would be just a very wild guess.
    If you can attach a copy of the workbook. Or, if that fails, paste a copy of the code to the forum.
    Be sure to use code tags when posting codes.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts