Hi all. I am getting "Run-time error '429': ActiveX component can't create object" error on the following line of this code 'Set LoopListWS = ThisWorkbook.Worksheets("Argus Macro")'
I checked for missing references but there are not any. Also, I have an older file with the same code that still works...
Please Login or Register to view this content.
pls click the star if you liked my answer!
Re: Run-time error '429' - VBA code help
Hi,
rather than an useless Worksheet variable why not directly use the worksheet CodeName ?!
Thanks for the reply! What does "worksheet CodeName" mean?
Re: Run-time error '429' - VBA code help
When the worksheet belongs to the workbook containing the VBA procedure so the worksheet property CodeName - like a Worksheet variable -
can be used, no changes when the worksheet is renamed like you can see on VBE side
for example Sheet1 (Data) where Data is the Name and Sheet1 the CodeName
then rather than Worksheets("Data").Range("A1:B9") you can directly use Sheet1.Range("A1:B9")
very usefull when an user renames the worksheet Data to Ledger for example …
I'm doubtful that it is that line which is causing an automation error. If the worksheet didn't exist you'd more likely expect an error #9.
Are you able to share a workbook?
I was able to just remove "Thisworkbook" from the code and use this line instead:
That seemed to work for some reason.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks