Does anyone know what would cause this error? I included a couple screen prints showing that the form exists, and that it is not misspelled in the code. What should I look for? TIA
Jason
Does anyone know what would cause this error? I included a couple screen prints showing that the form exists, and that it is not misspelled in the code. What should I look for? TIA
Jason
Last edited by jasoncw; 10-22-2008 at 04:28 PM.
Hello Jasoncw,
Is InputAuditors a named range? If so, change your code to this...
Sincerely,Please Login or Register to view this content.
Leith Ross
Thanks for the reply, Leith.
Yes, it is a named range, but unfortunately, that did not change anything. Any other ideas? I will hesitantly post my workbook if needed.
Hello jasoncw,
I gather you have some sensitive information in the workbook. If you can "clean" it then post it that would help. If time is factor, you could email it to me and I will post the corrections made here in the forum.
Sincerely,
Leith Ross
Thanks again, Leith.
I believe I solved the problem. This was a snip from a different file, and apparently in the other file, I was using the variable Aud as an array. So I was getting the error here:
Since it is a range variable, I changed it to:Please Login or Register to view this content.
All is good now. Thanks again.Please Login or Register to view this content.
Jason
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks