Hi
I have an excel with the following code:
I when I try to add new named rages the code does not work and give the error "run-time error '1004' method 'range' of object '_worksheet' failed".
Please Login or Register to view this content.
is there is a limit for the number of named ranges that can be included in such piece of code? how can I fix it?
Thanks for your help
//E.B
Have you checked that all the named ranges are valid?
If posting code please use code tags, see here.
Yes I did, even if I add a non-named rage it wont accept it! it feels like the code is limited to a certain number of ranges "22 in this case" which is strange.
The code actually works for me when I create all the named ranges in your code.
What happens when you try this code?
That code loops through each of the named ranges individually rather than all of them in one go.Please Login or Register to view this content.
why not use Union, to return range that has many areas. It's limited to 30 args.
Also I would suggest add named ranges in array and then loop trough elements in the array and then trough each cell like you do now.
Edit: That is what Norie did..
@ Norie: we did our post at the same time
If you are pleased with a member's answer then use the Star icon to rate it.
It did not work, I tried to test the code in a new sheet with new named ranges, and got the same result, only up to 22 named range will work, if I add the 23rd it gives the Error, here is the complete code I have used in the test sheet:
Please Login or Register to view this content.
Did you try the code I suggested in post #4?
I tried, but did not know how to combine it with the entire code that I have, the one in post#6. Can you look at it and help me with that. I have to say I can so little VBA i.e. doing some basic amendments to a code is OK, but to change the whole code or write a new part of it is something that I cannot.
/E
Here's your code from post #6 and my code from post #4 combined.
Please Login or Register to view this content.
range will only accept 255 characters for its argument
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks