ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Runtime Error 9 (https://www.excelbanter.com/excel-discussion-misc-queries/28148-runtime-error-9-a.html)

Lizz45ie

Runtime Error 9
 

I'm receiving a Runtime error 9 when trying to update a file that
contains a macro. I don't what is causing the error.


--
Lizz45ie
------------------------------------------------------------------------
Lizz45ie's Profile: http://www.excelforum.com/member.php...o&userid=23410
View this thread: http://www.excelforum.com/showthread...hreadid=374590


Chip Pearson

What line of code is causing the error? An error 9, "subscript
out of range," occurs when you're attempting to retrieve a
non-existant item from a collection.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Lizz45ie"
wrote in
message
...

I'm receiving a Runtime error 9 when trying to update a file
that
contains a macro. I don't what is causing the error.


--
Lizz45ie
------------------------------------------------------------------------
Lizz45ie's Profile:
http://www.excelforum.com/member.php...o&userid=23410
View this thread:
http://www.excelforum.com/showthread...hreadid=374590





All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com