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

Abhijyot Das

New member
Joined
Apr 27, 2014
Messages
1
Reaction score
0
Points
0
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.
 

Charles

Member
Joined
Feb 17, 2013
Messages
34
Reaction score
0
Points
6
Location
Biloxi
Excel Version(s)
Mac Excel 2011
Hi,

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.
 
Top