I have the code below, when i try and run comes up with runtime error 91
Any help would be greatly appreciatedPlease Login or Register to view this content.
I have the code below, when i try and run comes up with runtime error 91
Any help would be greatly appreciatedPlease Login or Register to view this content.
You never assigned a range to your rng variable.
Rory
1) This code is probably in a sheet module - please mention such details (or better attach sample file).
2) When code first callsrng variable is not assigned (Nothing)Please Login or Register to view this content.
and in function RdmCell you get error 91 because code tries to count cells in not assigned Range Type variable.
May be it would be enough if you preassign rng before entering a loop like:
Please Login or Register to view this content.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks