Hi everyone...
im trying this simple vba code but im getting an error...
Method 'Formula' of object 'Range' failed
MY EXAMPLE:
cell A1=0,125 B1=1025 C1=1,016 D1=1000 and in cell "E4" will return = A1/B1*C1*D1 but i only want the calculations to be made when in cell "E4" IS NOT BLANK SO , when i type in cell "E2" THE MACRO SHOULD RUN...BUT ONLY WORKS WITH A BOTTON...
Range("E1").Formula = "=RC[-4]/RC[-3]*RC[-2]*RC[-1]"
THANK YOU.
im trying this simple vba code but im getting an error...
Method 'Formula' of object 'Range' failed
MY EXAMPLE:
cell A1=0,125 B1=1025 C1=1,016 D1=1000 and in cell "E4" will return = A1/B1*C1*D1 but i only want the calculations to be made when in cell "E4" IS NOT BLANK SO , when i type in cell "E2" THE MACRO SHOULD RUN...BUT ONLY WORKS WITH A BOTTON...
Range("E1").Formula = "=RC[-4]/RC[-3]*RC[-2]*RC[-1]"
THANK YOU.