Hi all,
For the life of me I can't work out why the below code isn't working. Is there something obvious I am missing? Does it need to be phrased differently for change objects?
It's getting stuck @ line 8 ' Range("Uncertainty_Components[[#Headers],[Uncertainty Source]]").Select'
Please help!
Please Login or Register to view this content.
Hey Diva,
VBA is a picky language. It doesn't know what you mean by your line 8. You also might have some confusion on which sheet (or workbook) the range is in.
1. Try to name your range using the names manager and use it in line 8. The name you have is specific to a defined table and might not work on older versions of Excel. Also, I've never seen the "[[..]]" construct before.
2. You've Selected a sheet and hope the range on line 8 deals with that range. Try to Activate that sheet to insure it is the active and current sheet.
3. It just occurred to me that code behind one sheet might not work on a second sheet. This had to do with "Scope" of VBA. If you want code to work on two different sheets, you need to move it to a module that can see both.
http://www.cpearson.com/excel/Scope.aspx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi Marvin,
you were absolutely correct, the code worked perfectly in another module but not inside the change module of the sheet.
To get around this I instructed the change code to run the another macro including the code.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks