Hi All
I'm pretty new to VBA and have run into a stubbon error when working on a textbook example.
The sample code is supposed to write settings from an add-in to the User Interface Worksheets.
The error is 'Run Time Error 9, Subscript Out of Range'
Any help with this would be greatly appreciated.
(Excel 2007 & XP Pro)
Mark
The code is:
Please Login or Register to view this content.
Last edited by Leith Ross; 11-20-2011 at 02:14 PM. Reason: Changed HTML Tags to Code Tags
On which line does it give you the error. When you are running the code and it encounters an error, the line will be in highlighted in yellow.
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]
Hi Arlette
just after the first For statement:
Set wksSheet = wkbTemplate.Worksheets(sSheetTab)
thanks,
mark
It will be better if you attach the workbook which contains this code so we can debug it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks