I am trying to determine what I call the "DefaultCell" of a given range, which is the upper left most cell of the range the user selects. When I run the selection through the code below for the second selection, I get the "Object required" error, and I can't target why. For the first range selection, its fine though.
Please Login or Register to view this content.
What's UserRanges?
If posting code please use code tags, see here.
Sorry, yeah that might be important. It is a collection of cells in a user selected range. There can be more than one collection.
I am trying to set firstCell (dim range) to the upper left most cell of the selected UserRanges collection (i.e. UserRanges(1)) and set it as a "default" value so that if the user repeats the value, it signals that all the ranges the user wants to select, are selected.
Last edited by Coleman34; 04-15-2015 at 04:28 PM.
So is UserRanges something you've defined/declared elsewhere?
yes, its part of a long sub Main() i would be willing to share, but it might be too long to post. Is there another option?
I think we would need to see more of the code, perhaps not all of it, to determine what the problem is.
If it's to long to post then you could upload a sample workbook with the code in it and, maybe some explanation of how you are using this function, and the rest of the relevant code.
PS Just forgot, might be helpful to know which line of code that's causing the error.
Man, you mean its not OBVIOUS? lol I worked with it so long yesterday that I I was brain fried.
The line bugging out is:
the rest of the relevant code (as i see it) is:Please Login or Register to view this content.
Please Login or Register to view this content.
Where is the code located?
Can you upload a sample workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
I did get it working. I needed to wrap the range data type as a variant data type because my collection was returning Variant Data types so the range data type addition was failing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks