Hi,
Would someone please help me?
I'm trying to copy data from a worksheet into a dynamic array that I wish to manipulate and then put into another Worksheet but get an error that I can't figure out.
I try via myArray = Sht.Range("A1:H17").Value and it works
but when I try to make it dynamic via myArray = Sht.Range(Cells(1, 1), Cells(LastRow, LastCol)).Value it fails! What am I doing wrong?
Full details in code :
Thanks
Please Login or Register to view this content.
is correct (No error) with 17 as lower bound and 8 as upper bound.Please Login or Register to view this content.
It is probably Sht cells(1,1) is blank, hence the error.
Last edited by AB33; 07-31-2013 at 12:39 PM.
Try this:-
Please Login or Register to view this content.
Thanks to you both for your responses and as a result I've found the problem which seems like a bug in the vba.
works without error irrespective of which Sheet is ActivePlease Login or Register to view this content.
as does
(Thanks MickG)Please Login or Register to view this content.
My original code of
works ONLY if Sheet2 is Active and gives the error if not.Please Login or Register to view this content.
I'm now very happy as this has be bugging me for days.
Last edited by Inventiveman; 07-31-2013 at 11:52 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks