PivotTable Aggregating Incorrect Data

PivotTables can be a great tool for analyzing large amounts of data. If you have a PivotTable that is pulling information from the wrong information, it can mess up your analysis efforts. This tip presents a few ideas for fixing a problem of data coming from the wrong place.

Read this tip »

(Thanks to Raymond Guzman, Tom Santi, Dave Newcomer, and Penny Edwards for contributing to this tip.)

Printing Multiple Worksheet Ranges

Need to print more than one portion of your worksheet? If you use named ranges for the different ranges you want to print, you can apply the technique in tip to print whatever named ranges you want.

Read this tip »

Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

Moving Cells Using the Mouse

Want to easily move information from one cell to another? A quick way to do it is to simply drag and drop using the mouse.

Read this tip »

Working with Elapsed Time

Work with times in a worksheet and you will eventually want to start working with elapsed times. Here's an explanation of what they are and how to best work with them in Excel.

Read this tip »

Turning Off Worksheet Tabs

Look at the bottom of a worksheet and chances are you will see tabs for all the worksheets in the current workbook. Want to hide those tabs? You can do so by using the steps described here.

Read this tip »

Getting User Input in a Dialog Box

Want to get some input from the users of your workbooks? You can do it by using the InputBox function in a macro.

Read this tip »

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Calling a Subroutine from a UDF

I have two macros in a workbook: a UDF and a subroutine that (among other things) adds a worksheet to the workbook. I cannot seem to call the subroutine from within the UDF. Is there a restriction about using CALL within a UDF? If so, why? If not, what can I do to call the subroutine?
—Yair Babad (provide an answer for this Help Wanted question)