I have a drop down in my spread sheet and the list is created from a
range on the spread sheet. The formula is : "=BI3:$BL3". When users
import from a previous version of the software some line change the
fomula to something like "=BI27:$BL27" I have been trying to check the
lines and reset their formula1 to the correct range however I keep
getting error 450
"Wrong number of arguments or invalid property assignment"
Does anyone know what I am doing wrong, or is there a better way of
correcting the problem.
I am using vb6.
The line that produces the error:
thisWb.Sheets("Project Sheet").Range(TYPE_COL & r).Validation.Formula1
= "=BI3:$BL3"