J
Joseph Tibiita
I recorded marcos in a workbook. I then saved the workbook uder a ne
name .
Naturauly I had to modify the macro ref file names to the new fil
name.
I can now run the macros , however I get the wrong results.
example:
i have this formular
=if(data!c5=0,0,data!c5/data!d5)
in the orignal workbook it works fine when I copy an
autofill the fields
in that column.
In the new workbook the formular is right but th
resutant value is a
constant for all the auto filled cells!! eg. if th
cell A1 = 3 all the other
cells A2 , A3 , A4 are dispalying 3 enven the formula
shows otherwise.
Please help :confused
name .
Naturauly I had to modify the macro ref file names to the new fil
name.
I can now run the macros , however I get the wrong results.
example:
i have this formular
=if(data!c5=0,0,data!c5/data!d5)
in the orignal workbook it works fine when I copy an
autofill the fields
in that column.
In the new workbook the formular is right but th
resutant value is a
constant for all the auto filled cells!! eg. if th
cell A1 = 3 all the other
cells A2 , A3 , A4 are dispalying 3 enven the formula
shows otherwise.
Please help :confused