General

Declaring variables for use in multiple worksheets
I agree that the value of the cell makes a perfectly good “Global variable”. I don't see any advantage to the function and I would not bother with the range name. The following is an example of how I might do it: Sub testit2() Dim strMode As String strMode = ThisWorkbook.Worksheets("First Sheet").Range("... 8 Apr 2010 12:37

Macro to hide worksheet based upon text in the name
Is it possible to have a macro that hides worksheets based upon text contained or not contained in the worksheet name? Suppose i have several worksheets but want to hide ony the ones that don't have the text "HOLD" in the name; worksheet names: Data_HOLD Data Selection_HOLD etc.... or maybe base it upon th... 8 Apr 2010 15:12

Format Question
I feel silly asking this because I know it should be easy, but I just can't figure this out. I have an Excel Spreadsheet and the data is in General format and displays with one decimal and with the percent sign like this: 85.1% or 96.3%. I need to use this data in calculations so I need it to be a number for... 8 Apr 2010 18:35

create chart from daily data and add trend lines for each week
Excel 2003 Is there a way to create a chart using daily data and create a trend line for each week. The data does not have an Saturday's or Sunday's. My data looks like this. Date Output Input 2/15/2010 229 215 2/16/2010 441 153 2/17/2010 205 43 2/18/2010 283 138 2/19/2010 609 121 2/22/2010... 8 Apr 2010 11:05

Sumproduct to count between two dates
Using Excel 2003 there are dates in F3:F19 and procedures, such as THR, in G3:G19 on the sheet East 2010. On a second sheet in the workbook I need to count the number of 7 different procedures for each quarter. Based on feedback found in other questions I have come up with this formula: =SUMPRODUCT((('East 201... 8 Apr 2010 12:37

Keyboard shortcut for Auto-filter
Hi! Anyone know a trick to switch auto filter on and off without going through the menu such as a keyboard shortcut? Ive got Excel 2003 and I dont mean "ALT + DOWN" :-) ... 8 Apr 2010 11:05

Area Charts in 2007 - how to bring data set to front?
I have an area chart where one set of data is larger than another and hiding the smaller set. How can I bring the smaller data set to the front so it is visible also? Thx Dave ... 8 Apr 2010 11:05

I have an excel file split 1 and 2 how do I restore it please ?
I have an excel file split 1 and 2 how do I restore it please ? ... 8 Apr 2010 11:05

Excel 2007 - Customised Menu
Good Afternoon, All. How can I created a customised menu in Excel 2007? Best Regards, Vanessa Simmonds ... 8 Apr 2010 08:23

using Vlookup to validate data
I have 2 spreadsheets with names and email addresses - File 1: 150 records File 2: 63000 records I need to check if each of the emails on file 1 are there in file 2 or not. If it is there it shoul show "yes" else show "no" when I do a Vlookup it gives me the email ids in the cell - I am not able to show a '... 8 Apr 2010 05:05