Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem updating nested IF statement results
I'm using the following formula to give a value to several items of data that I want to link into a Visualbasic program: =IF((AND($U$1=Y2,Z2="D")),1,0), where $U$1 is the copy of a date in U2 (set up as a relative link to another spreadsheet. However, when I run a macro to copy the date in U2 (as either values or values and number formats) into U1 the formula does not update in the row where the condition is met. Why does it not update and how can I solve this problem? Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem updating nested IF statement results
I just knocked up some simple simulation code, and it worked for me.
Where is the formula (which cell)? Show the copy code. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Zakynthos" wrote in message ... I'm using the following formula to give a value to several items of data that I want to link into a Visualbasic program: =IF((AND($U$1=Y2,Z2="D")),1,0), where $U$1 is the copy of a date in U2 (set up as a relative link to another spreadsheet. However, when I run a macro to copy the date in U2 (as either values or values and number formats) into U1 the formula does not update in the row where the condition is met. Why does it not update and how can I solve this problem? Many thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem updating nested IF statement results
Bob,
Many thanks - the copy code is: Selection.Copy Range("U1").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False The formula is in cell: AG20. AC20 has the value 08/09/2007 and AE20 has the value "E" Best wishes, Tony "Zakynthos" wrote: I'm using the following formula to give a value to several items of data that I want to link into a Visualbasic program: =IF((AND($U$1=Y2,Z2="D")),1,0), where $U$1 is the copy of a date in U2 (set up as a relative link to another spreadsheet. However, when I run a macro to copy the date in U2 (as either values or values and number formats) into U1 the formula does not update in the row where the condition is met. Why does it not update and how can I solve this problem? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nested IF SUMPRODUCT updating to closed workbook | Excel Worksheet Functions | |||
Nested if statement and vlookup problem | Excel Programming | |||
Screen Updating problem with nested subroutines | Excel Programming | |||
Nested if statement problem! | Excel Programming | |||
Problem with nested IF_OR statement | Excel Worksheet Functions |