Using a Formula to get Range of Data to an Array
 

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

Using a Formula to get Range of Data to an Array
 

try this site

http://www.bmsltd.ie/MVP/Default.htm

--


Gary


"Chris Paterson" wrote in message
...
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

Using a Formula to get Range of Data to an Array
 

Cheers for that I will have a look :)

"Gary Keramidas" wrote in message
...
try this site

http://www.bmsltd.ie/MVP/Default.htm

--


Gary


"Chris Paterson" wrote in message
...
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