nikki333
10-05-2018, 01:35 PM
Hi folks
I'm trying to put some intontiguous ranges (concatenated as string) into formulas via vba.
It seems tricky, excel uses every way to prevent me from achieving .)
Anyways, for the formulas, I gather range.addresses(0,0) from ranges, add the worksheet.name between "'" and add them to a string. (e.g. 'GF'!U8:U70;'Fo1'!U8:U80;'Fo2'!U8:U41;'Fo3'!U8:U56)
The strange thing is that excel will ignore the beginning "'" and remove it from the final formula in some cases and throw an error, and strangely for some ranges not .)
WTF, any ideas, cheers
I'm trying to put some intontiguous ranges (concatenated as string) into formulas via vba.
It seems tricky, excel uses every way to prevent me from achieving .)
Anyways, for the formulas, I gather range.addresses(0,0) from ranges, add the worksheet.name between "'" and add them to a string. (e.g. 'GF'!U8:U70;'Fo1'!U8:U80;'Fo2'!U8:U41;'Fo3'!U8:U56)
The strange thing is that excel will ignore the beginning "'" and remove it from the final formula in some cases and throw an error, and strangely for some ranges not .)
WTF, any ideas, cheers