Hello everybody,
I am trying to speed my macro a little bit, and I figured out that I can use array. But it's not working. Where is the issue?
The code without array is working OK, but very slow - 90 seconds:
Please Login or Register to view this content.
Thanks for any help!Please Login or Register to view this content.
Mario
"not working" means...?
this line
should bePlease Login or Register to view this content.
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
The Macro is just NOT doing the job. I still have the "#NA", "NoRecords" etc. values in cells.
Try something like this
instead ofPlease Login or Register to view this content.
Please Login or Register to view this content.
Now I got type mismatch error at line:
When I put On Error Resume NExtIf ArrayA(Lrow, Lcol) = "#NA" Or ArrayA(Lrow, Lcol) = "NORecords" Then ArrayA(Lrow, Lcol - 1) = "": ArrayA(Lrow, Lcol) = "": ArrayA(Lrow, Lcol + 1) = ""
Macro removes everything from an Array and I got empty cells
Here goes the whole code:
Please Login or Register to view this content.
Last edited by djvino; 05-15-2012 at 08:02 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks