Archive for October, 2008

Excel Function to Display Worksheet Name

Posted on October 29th, 2008 by Joseph Harris

Q: Hi, Can you tell me how to show the worksheet name in a cell in my workbook? Thanks, Ted A: Ted, You can do this with the built in functions in Excel. The CELL function with the filename argument, =cell(“filename”), will return the entire path of your workbook along with your current worksheet. We [...]

Playing with VBA in Excel, Without Knowing VBA!

Posted on October 27th, 2008 by Joseph Harris

Introduction to user defined functions and VBA in Excel.

Excel Version Differences

Posted on October 26th, 2008 by Joseph Harris

I try to make all of the advice I offer on this blog generic to all Excel versions. Sometimes it is useful to know some of the more important (or useful) differences. Below are some of the differences that I try to keep a mental note of: 2000 Digitally signed macros Pivot Charts User forms [...]

Manual Calculation

Posted on October 24th, 2008 by Joseph Harris

There are times when you may have a workbook that has 20 sheets with external links and you are forced to wait after every small change you make due to the size of the workbook. When those times occur, you may want to turn on manual calculation. Manual calculation turns off automatic calculation until you [...]

Conditional Formatting

Posted on October 23rd, 2008 by Joseph Harris

Q: Dear ExcelYogi, Thank you for all your wonderful advise and guidance! I am hoping you can help me yet again. I understand the basics of conditional formatting, but is it possible to do something more advanced such as highlighting entire rows based on a criteria? Thanks again! Amber A: Amber, I see this question [...]

Vlookup – My Favorite Function

Posted on October 23rd, 2008 by Joseph Harris

Vlookup