VB Range Error

[dpman]

Good Afternoon,

I'm running a macro which is designed to populate one sheet using another and i am getting a:

"Method 'Range' of object '_Global' failed" Error

The error lies in the following code:

Range("CFaR_" & MA_rangenum(counter)).Value = MA_range

Any help would be greatly appreciated.

Many Thanks
Dpman

 

[doofusboy]

Excel expects to find row and cell references between the red parentheses below [something like "A1" or "A1:B5"]:

Range("CFaR_" & MA_rangenum(counter)).Value = MA_range

Evidently your "CFaR_" & MA_rangenum(counter) does not resolve to a proper cell/range reference.