Hi,

I have a formula to get a variable range of data from my Task Log worksheet

TaskSpendLength = Worksheets("Task Log").Range("$GH$42")
tempRangeFormula = "='Task Log'!R44C190:R44C" & 190 +
TaskSpendLength

I am trying to use this formula to get an array of values from my Task Log
sheet so
that I can perform some array multiplication using the ScalarMult function
below

convertedArray = ScalarMult(Worksheets("Task
Log").Range(tempRangeFormula), Worksheets("Sheet2").Range("E6"))

where the E6 cell contains an integer

I get a Run time error: 1004 application defined or object defined error
appear, it is
something to do with this bit "Range(tempRangeFormula)" I think but I am
stumped. I have tried using the formula directly within the range brackets
and I get a similar erro. I can't work out what is wrong it may just be my
brain is frazzled seeing as its friday and all but if any one can help I
would be grateful.

Chris