Run-time error '1004': Application-defined or object-defined error

[plasma33]

Hi guys,

I am trying to run macro through hyperlink and when trying to do that its giving me a run time error. Below is the code that i am trying to implement.

Please Login or Register  to view this content.

its giving me an error at the following code->

Please Login or Register  to view this content.

Currently I have enabled the following references:

Visual Basic For Application
Microsoft Excel 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Object Library
Microsoft Forms 2.0 Object Library
Windows Script Host Object Model

thanks in advance guys...

Cheers
plasma33

[plasma33]

its working guys....here is the modified code->

Please Login or Register  to view this content.

Cheers
plasma33