Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros
This worked on excel 2003. I don't know what could be wrong. Make sure the
"SAME" sheet name is in both the ISREF and the FALSE part of the if statement. "Alex" wrote: Whenever I inputted the formula that you provided, it still gives a reference error if the page is not there. Any other ideas? Thanks again for all your help Joel Alex "Joel" wrote: I didn't know if you were refering to VBA code or a Worksheet function. =IF(isref('Page 1'!L46=0),0,'Page 1'!L46) "Alex" wrote: The macro is doing exactly what I want. Data from a specific cell needs to be referenced to another cell in the summary. In sheet 1 cell E21 there is =sum(E1:E20) In the summary, i'd have it 'Page 1'!E21 in the summary, I have spaces allocated for Page 1-16 With the new pages, I want to have it where, if the new page is there, then it shows the value in E21, if it is not there, then show a value of 0 =IF('Page 1'!L46=0,0,'Page 1'!L46) ----When I change it to page 2 and page 2 is not there, then I get a #REF error, which throws off all my other formula's |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Macros inside macros, and pasting into macro code. | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming |