Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Typing vs VBA
I have a 9-column spreadsheet where Col H is an IF that points to a pivot
table on a separate worksheet (same .xls file, though). Column I is an IF that first points to the cell in Col H and then pulls additional data from the same pivot table. I can key the function in Col I and it works without a problem. I am trying to get a macro recorded to enter the function and I get an Unable to Record dialog when I key in the function with the macro recorder turned on. Ultimately, the function I want to get into I2 is this: =IF(INDIRECT("RC8", FALSE)="Auto No Run", IF(GETPIVOTDATA("Comp Status", TCCompositionAnalysis!$A$3, "TC ID", INDIRECT("RC1", FALSE), "Comp Status", "Error", "ManAuto", "Auto"), "Auto Error", IF(GETPIVOTDATA("Comp Status", TCCompositionAnalysis!$A$3, "TC ID", INDIRECT("RC1", FALSE), "Comp Status", "UnDev", "ManAuto", "Auto")0, "Auto UnDev", IF(GETPIVOTDATA("Comp Status", TCCompositionAnalysis!$A$3, "TC ID", INDIRECT("RC1", FALSE), "Comp Status", "Maint", "ManAuto", "Auto")0, "Auto Maint", "Eval This Row"))), IF(INDIRECT("RC8", FALSE)="Run Auto", "", "")) So after repeated attempts to get this into the cell... I've keyed it into the editor with double double quotes for the editor. 1. =IF(INDIRECT("RC8", FALSE)="Auto No Run", "XXXX", "ZZZZ") 2. XXXX: IF(GETPIVOTDATA("Comp Status", TCCompositionAnalysis!$A$3,"TC ID", INDIRECT("RC1", FALSE), "Comp Status", "Error", "ManAuto", "Auto"), "Auto Error", "AAAA") 3. AAAA: IF(GETPIVOTDATA("Comp Status", TCCompositionAnalysis!$A$3,"TC ID", INDIRECT("RC1", FALSE), "Comp Status", "UnDev", "ManAuto", "Auto"), "Auto Script", "BBBB") 4. BBBB: IF(GETPIVOTDATA("Comp Status", TCCompositionAnalysis!$A$3,"TC ID", INDIRECT("RC1", FALSE), "Comp Status", "Maint", "ManAuto", "Auto"), "Auto Maint", "???") 5. ZZZZ: IF(INDIRECT("RC8", FALSE)="Run Auto", "", "")) I got the first 2 pieces in without throwing the error. But once I replace "AAAA" with the piece of function... Unable to Record. Before I MacGuyver a different solution that I have in mind.... can anyone shed some light on why this is happening? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where has my typing bar gone? | Setting up and Configuration of Excel | |||
Get #### when typing | Excel Discussion (Misc queries) | |||
name typing | Excel Worksheet Functions | |||
Is there a better way (with less typing)? | Excel Programming | |||
Is there a better way (with less typing)? | Excel Programming |