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

**Willer** · 10-23-2011, 09:26 AM

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** · 10-23-2011, 09:31 AM

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

Originally Posted by 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 ;-)

**watersev** · 10-23-2011, 09:33 AM

hi, Willer, try to replace:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

**Willer** · 10-23-2011, 01:56 PM

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** · 10-23-2011, 02:10 PM

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** · 11-17-2011, 08:22 AM

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

**watersev** · 11-17-2011, 08:58 AM

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

**Willer** · 11-17-2011, 03:02 PM

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