Do you have a quick-reference file?

[MrKowz]

Hey all, was wondering if anyone here uses anything they've printed out, or keep an excel file, handy for needing to reference to things.

I keep a printout of all the color indicies, as well as the column number of each column. That way I can quickly check to see that column CO is 93, or that a certain shade of green might be 50 or 35.

Also, my desk is littered with post-it notes of little snippets of formula I see around the forums here like:

=LOOKUP(value,{ARRAY},{ARRAY}) to remind me that I can create my own arrays within the formula

or

=ADDRESS(MATCH("zzzzzz",A:A),1,4) to help me remember how to find the address of a the last cell of a column that contains a text value.

 

[schielrn]

I don't have a cheat sheet, but I use a favorites folder on this site.

 

[RoryA]

Workbook colours are workbook-specific, so I have a workbook that shows a form with the colours of the activeworkbook. Addresses I just do from the Immediate Window (?Range("CO1").Column). I have quite a large library of code snippets though.

 

[TinaP]

Oh, yeah, I keep several files in a folder. One shows all the different formatting options: fonts, shapes, colors, etc, as well as the code to produce them. Another has code snippets. Yet another a list of all worksheet functions. The last one has code and tables related to graphs.

I don't use the files solely for documentation--I frequently experiment in them before I use the information in live workbooks. It's my personal version of the Test Here forum. When coding, I'm always thinking "I did this once before...what workbook was that?" This way, it's all together and I'm not pulling my hair out.

 

[Michael M]

I'm in a paperless office.....LOL !!
Anything I do goes into electronic file.
I keep a spreadsheet with hundreds of macros, snippets and functions.
That way it's a simple copy and paste.....and everybody still manages to get their post in before me !!

 

[Domski]

I use my Personal.xls, have a folder I store example files in and bookmark the odd gem but other than that can generally find what I need with a quick Google. I did think about setting up a database where I could start a decent collection of code and formula examples with tags that I could search on but just haven't got round to it yet.

Dom

 

[RoryA]

If you buy PED2, you get the .Net Co Library free...

 

[Michael M]

Hey Dom
I started a DB and then realised I had Google, so gave it up as a waste of time and space, doing it all again......And as you know no matter how many examples we have, the OP always wants something different !!