General

Cycling through workbooks
Hello, I'm creating various spreadsheets for managers listing accesses to various programs in a number of tabs, to avoid the out of memory error, I've broken it down into four stages. The first stage creates the a file for each manager and copies the first batch of records into a given manager's spreadshe... 4 Jul 2008 17:11

2008 to 2007 - How can I find the extremities of a worksheet?
I am trying to save a 2008 excel file to be compatible..... I have written most of the work book myself but there are 4 worksheets by another. I get a compatibility issue and the sheet causes below 2008 to crash when opening..(previously the whole book worked fine before the other person helped) Any ideas how ... 4 Jul 2008 14:07

Change Field On Pivot Table Using VBA Input Box
Does anyone have a VBA code that will change a field on a pivot table using an input box? Ex: The Row field of the pivot table is currently 'Date'. I want an input box stating, 'Please enter the name of the field you want to change the Row field to.' I would enter 'Week'. The Row field would change from 'Date'... 4 Jul 2008 14:07

Conditional Formatting on empty cells
I'm setting up a new report for the month of July and creating formatting rules for data that will be entered throughout the month. However, when I apply my rules to cells that have not yet got data entered (eg. for next week) it is showing up as "formatted" even though the cell is empty. Is there an override... 4 Jul 2008 18:12

Combine two columns and delete original
when I combine the two columns (B and C) into A and delete B and C all I end up with in column a is the formula not the info from column b and c Can you help Thanks in advance ... 4 Jul 2008 14:07

Getting cell index from cell to the right
Hi, I want to have a formula that retrievs the index from the cell to the right of the cell with the formula. I know that the formula below gives the index of the cell you are in but that doesn't help me much unfortunately. Is there a simplier way or maybe a way that utilises this code? =SUBSTITUTE(SUBST... 10 Jul 2008 11:20

cell is blank then dont count range
Hi This seems to be simple in my head but cant work it out!, in my speadsheet i want to count f3 & a3 which is easy but if f3 is blank then i dont want to count any cells any help would be great!! ... 5 Jul 2008 07:25

personalised rota
This maybe quite simple but I seem to be getting into quite a state. I have a workbook comprising of 2 worksheets;- #1 – “roster” #2 - “myrota” The first compiles a roster for the 16 man department for the coming week and is compiled automatically on entering the w/c date using a VLookup list. What I want... 4 Jul 2008 13:05

Can I automatically hide a column with zero values in Excel
I have a large spreadsheet which will be populated based on the selection from a drop down list box. The values populated will contain alot of zero values which I have blanked out using the tools/options functionality but I would like to automatically hide the column if all values within a range in that column ... 4 Jul 2008 15:08

Not at all clear on use of variables and/or object variables
I jumped on the Excel (VBA) bandwagon some years ago. I have dozens of books and reference them constantly. In no book or in my visiting any newsgroup have I been able to clearly make the distinction between when to engage a regular variable versus an object variable - particularly as regards the Range object. ... 4 Jul 2008 14:07