Can anyone tell me what the problem is with this code snippet?
Range("D5").Formula = "=match(D6,ChTables!$A:$A,)"
Range("D7").Formula = "=OFFSET(ChTables!A1,D5,53)"
Range("D8").Formula = "=OFFSET(ChTables!A1,D5,47)"
Range("D9").Formula = "=OFFSET(ChTables!A1,D5,51)"
Range("D10").Formula = "=OFFSET(ChTables!A1,D5,72)"
The code for "D5", D7" & "D9" return the correct answers, although "D7" adds a decimal number to the referenced integer!
"D8" & "D10" both return 0, although the function arguments box (fx) show the correct numbers, so I must have the correct references.
Advice would be much appreciated
Range("D5").Formula = "=match(D6,ChTables!$A:$A,)"
Range("D7").Formula = "=OFFSET(ChTables!A1,D5,53)"
Range("D8").Formula = "=OFFSET(ChTables!A1,D5,47)"
Range("D9").Formula = "=OFFSET(ChTables!A1,D5,51)"
Range("D10").Formula = "=OFFSET(ChTables!A1,D5,72)"
The code for "D5", D7" & "D9" return the correct answers, although "D7" adds a decimal number to the referenced integer!
"D8" & "D10" both return 0, although the function arguments box (fx) show the correct numbers, so I must have the correct references.
Advice would be much appreciated