I am using the following code to download some date and then put it into specific columns of another sheet.
I have been first putting the downloaded data into a variant to speed up the distribution. For a reason I have been unable to discover, the linePlease Login or Register to view this content.
BudgArr = Range("Budget").Value has started to cause an error message "Method Range of object '_Global' failed.
This is the message that usually I see if I have misspelled a range name. This not the case now though. The range is present in the named range list, and is designated correctly.
On earlier tests this part of the code worked so I must have changed something, can anyone help?
John
Bookmarks