trodneyrotter
New Member
- Joined
- Jun 20, 2014
- Messages
- 15
Hi,
I'm using a large excel model that uses a datadump function to move data from inputs into a data dump sheet.
I've added a tracker to the model to track changes made to it and now the data dump function is really, really slow.
Is there a way to use If and Then with sub procedures so I can say If the procedure called Datadump is called Then exit sub?
I can do this for if Value = "" Then Exit Sub, but can't figure out how to do this for if a sub procedure is called.
Any help gratefully received.
Thanks
TR
I'm using a large excel model that uses a datadump function to move data from inputs into a data dump sheet.
I've added a tracker to the model to track changes made to it and now the data dump function is really, really slow.
Is there a way to use If and Then with sub procedures so I can say If the procedure called Datadump is called Then exit sub?
I can do this for if Value = "" Then Exit Sub, but can't figure out how to do this for if a sub procedure is called.
Any help gratefully received.
Thanks
TR