I am getting the Run-time error 9 message ...with this statement (or a variation ) There are no spelling issues. The sheet exist and....cannot figure out why.
Any suggestions what this could be. Started excel a few times but keep getting hit
Worksheets("Sheet3").Range("A17").value = "Test"
Thank you
Are you using this code in workbook1 while the sheet3 is in workbook2? (workbook1 and 2 are just example names).
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
As suggested by Arlette, you are using the 'Worksheets' object without any reference to which workbook the object relates to, hence Excel will by default use the workbook that has the focus on that specific moment in time.
you could use:
to ensure that Excel always looks for SHeet3 in the same workbook as where the code is running.
Please Login or Register to view this content.
If you like my contribution click the star icon!
or your code is in the Thisworkbook module of a workbook that doesn't contain a Sheet3 in which case the code always refers to the workbook containing the code no matter which workbook is active
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks