Runtime error '1004' Application-defined or object-defined error Comment

[Willer]

Runtime error '1004'
Application-defined or object-defined error

Just Can't see What's Wrong..? there IS a Comment in cells(6,1) on "Sheet3" ..?

Module Level Function:

Please Login or Register  to view this content.

Will be Passing wks as String, and the Range to Function, when got bug worked out..!

Any Help/Feedback would be appreciated ;-)

[devile]

Updated code, i'm fairly new to this too, but, see how that works...

Runtime error '1004'
Application-defined or object-defined error

Just Can't see What's Wrong..? there IS a Comment in cells(6,1) on "Sheet3" ..?

Module Level Function:

Please Login or Register  to view this content.

Will be Passing wks as String, and the Range to Function, when got bug worked out..!

Any Help/Feedback would be appreciated ;-)

[watersev]

hi, Willer, try to replace:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[Willer]

thx guys , once past that point i found had also Mised out the .AutoShapeType

Final Snippet, Works a Treat ..!

Please Login or Register  to view this content.

[watersev]

if the issue is Solved, please click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

[Willer]

Where is Edit .. Go Advanced ..? Cant Seem to Find it..! :-/

[watersev]

as per post #5, you need to contact moderator to mark it Solved

[Willer]

Ok Thanx, will ask a MOD ;-)

Is the 2 Days.. From First Post of the Thread, any Post Afterwards.. Or the last Post..?
.. and why only 2 days, are all Questions Supposed to be solved within 2 days :-P

Sorry if I Appear Flippant.. Found this NB very Helpful :-D