Apr 6 2010 Version 020 now available.
STAIN
Emboldened by Rudi's comments, I have put together a crude package for anyone interested in automating the process of creating range named cells from multiple label cells (FabNameCollection), upgrading cell formuale to replace cell references C43 with range names (FormulasToRangeNames) and a means (MoveFormula) to sort the formulae in a worksheet so that the calculation flows in a linear fashion top to bottom.
The code is not robust. It was written to speed up my work in making repeated clean-ups of a set of client workbooks. In particular, I am waist-deep right now in getting a better understanding of how to use the macros to effect the best clean-up job in a workbook.
There's one more macro of which I am particularly fond: StringFunction. This macro takes a selection of cells and fabricates a user-defined VBA function, thereby eliminating the need for any formulae code to be left within the worksheets.
I'm happy to discuss this in this thread or, if it gets too personal, by PM and email.
Before anyone says "Thank You", I'd like to point out that just about everything I know about VBA I learned from the fine people in this and previous incarnations of this Lounge.
You know who you are.
Thank You.
Fri 2 Apr. Five video tutorials (scroll down ...)
Fixing ugly workbooks (Excel 2000+)
-
- PlutoniumLounger
- Posts: 15636
- Joined: 24 Jan 2010, 23:23
- Location: brings.slot.perky
Fixing ugly workbooks (Excel 2000+)
Last edited by ChrisGreaves on 06 Apr 2010, 20:55, edited 2 times in total.
There's nothing heavier than an empty water bottle
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Fixing ugly workbooks (Excel 2000+)
The tiger is out the cage!!! You go boy!
Warning: With Chris's approach to: Make computers work... Please note that your PC must have a high spec processor to keep up with this hard PC labour!
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- PlutoniumLounger
- Posts: 15636
- Joined: 24 Jan 2010, 23:23
- Location: brings.slot.perky
Re: Fixing ugly workbooks (Excel 2000+)
Or be sped up.Rudi wrote:... your PC must have a high spec processor ...
There's nothing heavier than an empty water bottle
-
- Microsoft MVP
- Posts: 656
- Joined: 24 Jan 2010, 17:51
- Status: Microsoft MVP
- Location: Weert, The Netherlands
Re: Fixing ugly workbooks (Excel 2000+)
There seems to be no download link?
-
- PlutoniumLounger
- Posts: 15636
- Joined: 24 Jan 2010, 23:23
- Location: brings.slot.perky
Re: Fixing ugly workbooks (Excel 2000+)
Correct.Jan Karel Pieterse wrote:There seems to be no download link?
Jan Karel, thanks for pointing this out.
The lack of a link was brought about by my supper guest arriving early (around 2pm), and getting me flustered.
(A very good night, thank you ...)
Please, Try again.
The page http://www.chrisgreaves.com/Greaves/Products/USER/Stain/UserGuide.htm now has a download link ("latest version") that currently points to http://www.chrisgreaves.com/Downloads/201003311326.zip
There's nothing heavier than an empty water bottle