=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
About this site.
This is a collection of Microsoft Excel tips, tricks, and code that I have found useful. Some will be straight from other sites and others are my own code examples. Feel free to comment on any of the posting with what has worked for you. You may also email me at cconover2@gmail.com.
Enjoy!!
My Blogs & Other Links
Labels
- .gif (1)
- Absolute (1)
- Add In (2)
- advanced filters (1)
- animation (2)
- Application Events (1)
- autofilter (4)
- Automatic Highlighting (3)
- bar graph (3)
- BeforeSave (1)
- Calculator (1)
- cell spotter (2)
- checkbox (1)
- clipboard (1)
- color (2)
- Comments (2)
- copy (1)
- Date (1)
- File Name (2)
- filters (1)
- highlighted cells (1)
- In cell (1)
- paste (1)
- performence (1)
- progress bar (1)
- Ranges (1)
- registry (1)
- row highlight (2)
- save (1)
- speed (1)
- splashscreen (1)
- timeline (1)
- userforms (5)
- vba (2)
- worksheet (1)
Blog Archive
-
▼
2006
(35)
-
▼
November
(27)
- Improving Performance in Excel 2007
- Filename in cell
- Showing worksheet tab name in cell
- New Custom Functions (work with highlighted cells)
- Row Highlight
- Displaying AutoFilter criteria
- Filter Highlight
- change a range of formulas from Absolute to Relative
- Comments Made Simple(r)
- Splashscreen
- Timelines in Excel
- More On Automatic Highlighting
- Bar Graphs In Cells
- Bar Graphs In Cells 2
- Bar Graphs In Cells 3
- Putting file drive location in the title bar
- BeforeSave only with Save, not Save As
- Quick Write: Me: 1, Registry: 0
- New Cell Spotter
- Day and Date Calculator
- Visibility In Excel Part 1 - Dynamic Comments
- Visibility In Excel Part 3 User Friendly Rows
- A Progress Bar
- Marlett checkboxes
- CUSTOM FUNCTION APPROACH (Autofilter)
- COLOR CODE WITH CALCULATE EVENT (Autofilter)
- http://www.cpearson.com/excel/vbe.htm
-
▼
November
(27)
No comments:
Post a Comment