LinkBack URL
About LinkBacks
The code continues beyond what I put in here but it is not important. When the code reaches the dataobj.range line of code, I get this error. Any ideas why it is happening?
Please Login or Register to view this content.
The code continues beyond what I put in here but it is not important. When the code reaches the dataobj.range line of code, I get this error. Any ideas why it is happening?
Please Login or Register to view this content.
Last edited by Mordred; 08-08-2011 at 12:45 PM.
You're getting runtime error 91 because it didn't find "SD-1" and your code assumes it always will.
If you change that to the following, it may still not find "SD-1", but it shouldn't give you error 91.Please Login or Register to view this content.
You may need to post an example workbook in order to determine why the value is not found.Please Login or Register to view this content.
-GregIf this is helpful, pls click Star icon in lower left corner
Hello cummins,
Welcome to the Forum!
When posting the same question on multiple sites, we ask you to include a link to where you have posted. This prevents members from answer questions that you may already have an answer to.
You should check back at Mr. Excel, as there are several answers already to this same question. Next time please let us know you have posted elsewhere.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks