Newbie: Error 1004
Sure. In the code you posted, you are working with another excel
application instance - it is unclear why or what application is running your
code, but you would have to incorporate my suggestion in your code so it is
properly qualified. Otherwise you might get '1004 - Method 'Range' of
Object'_Global' failed because your unqualified references are inconsistent
with what you are trying to do.
You didn't post your revision, so no specific suggestion can be offered.
--
Regards,
Tom Ogilvy
"Barry Aylett-Warner" wrote in message
...
Tom,
thanks for the suggestion - am now getting '1004 - Method 'Range' of
Object'_Global' failed.
Any thoughts?
Regards
Barry
"Tom Ogilvy" wrote in message
...
numrw = Ubound(Scores,1)-Lbound(Scores,1)+1
numcol = Ubound(Scores,2)-Lbound(Scores,2)+1
Range("A1").Resize(numrw,numcol).Value = Scores
change A1 to the upper left corner where you want the data to start.
--
Regards,
Tom Ogilvy
|