Link to home
Start Free TrialLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Small Fix to Macro for Range Addition and Expansion

I am working on a WS Application and IrogSinta (EE Pro.) recently built a Macro for me that auto extends a Current Year in two directions (Past/Future).  I need 2 small mod.s to this code before moving on.

1.) When a Column is added, either before or after the Current Year, it needs to be blank.  This is because information/data will be put in that is not the same as the current year.

2.) I need one more button that "resets All". What this means is it does exactly what the current reset button does but also clears the current year data.

That's it for new!

Thank you in Advance,

B.
Financial-Model-v2.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Faustulus
Faustulus
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bright01

ASKER

Faustulus,

Sorry for the delay.  I was robbed in Brussels at the train station and lost my laptop.

Great work!  Perfect and well written.  I will be posting another "next function" on this shortly.  Hopefully you will continue to pursue this.  

Thanks again,

B.
Faustulus,

Sorry for the delay.  I was robbed in Brussels at the train station and lost my laptop.

Great work!  Perfect and well written.  I will be posting another "next function" on this shortly.  Hopefully you or IrogSinta will continue to pursue this.  

Thanks again,

B.
Ah-yah! Aren't we all getting robbed in/by Brussels?
Hahaha!  If you're in Europe then "yes!"  I just happened to have the general population take it before it went through the political machinery!!!!  Lost a lot in the episode.

Hey...just posted my next version of this app. I'm building; if you get a chance, take a look.

Much thanks and "keep the faith"!

B.