I'm getting this error when hitting the button called "Create Specification List". It was working for weeks and now it's giving me this error. I will upload an example of the sheet I'm working on.
Any help would be greatly appreciated!!
I'm getting this error when hitting the button called "Create Specification List". It was working for weeks and now it's giving me this error. I will upload an example of the sheet I'm working on.
Any help would be greatly appreciated!!
I figured it out, I inserted a column in place of another and I didn't turn it back into a range.
2 of your named ranges seem to have issues... that's probably why. In the Formulas tab, go to Name manager and see if fixing the ranges solves the problem.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
That cannot have worked, you're combining (Union) of more than one range.
You assign a variable and you set with Union(....) then it might work
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks