Search:

Good one Steve!

I use software from Cognos (Analyst ver 8) for budgeting. There is an Excel Addin that can create reports based on the Budget database.
We are switching from Excel 2003 (running on XP) to Excel 2007...

The "GetFormula" is a range name. On sheet AnswerKey click on cell A11. Then access the menu Insert | Name | Define... then click on GetFormula in the drop down.
The range name is equal to the...

Did you check to see if there are macros in the workbook?

Thank you very much Hans for all your help.

Thank you Hans. I will have them give it a try.
I used to get emails when someone replied to my posts. I have not gotten them this time. I looked at my profile but it seemed ok. Any ideas?

Thanks...

Thanks Hans,
I can create a template that contains the Autotext entries and put it in a common network folder. How do I tell Word that any new entries should go there instead of Normal.dot?

Word 2003
Operating System: XP Professional Version 2002 SP 3

I am not sure it is even possible but if it is, someone in this Lounge would know.
Two of my coworkers would like to be able to...

I decided to combine the formulas so they could be copied down the rows.
Take a look at the attached workbook.

If the formulas work the way you want them to, you can copy them down the rows.

I may be way off - but its a shot.
Take a look at the attached workbook that uses VLOOKUP formulas.

Would you be able to use Auto Filter instead of the macro? The Auto Filter has options to Sort Ascending and Sort Descending.
Just a thought.

Nice! Much better than Select Case.

Select Case might be easier than the multiple IF statements.

Copy the formula down a enough rows to cover the number of sheets in the workbook.

Formulas cannot insert (or delete) rows. VBA would be needed to get this done.

Steve,

Good to know. Thanks

Are you referring to the lack of underline for the spaces between words?
If so, you could replace each space (that you want to appear underlined) with _
Then the entire section is underlined.

The formula =Rank should do the job.

Chuck

Rich,
I had the same problem except I open the workbook in both versions. The macro for 2003 fails in 2007.
I changed the code to determine what version it was in and then run the proper sub. I...

Congratulations Bob!

From all the posts I have read on this site - I know the help is appreciated!

Good one Hans

Hans,

Thanks. Maybe I should let them have spaces in the tab names....
I will modify the code as suggested.
Thanks
Thanks also for the code this was based on.

You Da MAN <img...

John,

No doubt there are many diffrerent ways to do it!
I am attaching the txt file of the code that fails. At the bottom of the text file, I marked where it fails and what the error message is....

Steve, Jan and John

Sorry for the delay in responding - I took a long weekend -away from work.

Thanks for the replies and suggestions.
I have some code that cycles through all the sheets that...

John,

Thanks! That will make my life much easier. For some reason, the users change the tab names by inserting spaces (even though they were told not to). This will take care of it.

Thanks...