In the attached spreadsheet I'm getting the Run-time Error 1004: Method 'Range' of object '_Global' failed. When I clcik to debug is brings me to the code for the Open Form button. I have no idea what is actually causing the error or how to fix it at this point. Please help.
Reality is stranger than fiction.
Hi,
I found the culprit (and I have been seening this problem more frequently these days). Either use Range or Cells but not both unless you want a Range of Cells.
So in your form you have four instances of something like this:
Change this to:
Please Login or Register to view this content.
and all your problems go away.Please Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Thanks for your reply Aboussetta! I also got the runtime error 1004, when I tried to COUNTIFS. Your answer helped me fix thatOriginally Posted by abousetta
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks