using the value of a macro variable in a concatenate formula
I guess NameStr has been defined as a name on the worksheet.
If this is true, use Range(Namestr).value instead
HTH
--
AP
"Simon W" a écrit dans le message de
ups.com...
thanks for the reply - unfortunately it gives me an 'application
defined of object defined error'. The concatenate formula works without
" & NameStr & " and NameStr is defined as i can put it into a different
cell not as part of the concatenate formula. Very grateful for any
suggestions.
|