Object Variable or With block variable not set - Error 91

[1337g4m3r]

Good day,

I'm not the fondest when it comes to knowledge with Excel, so slightly asking a newbie question and looking for a possible resolution.

The current output I have is as follows:

Please Login or Register  to view this content.

I've gotten this to work before without receiving this error, unsure of what I changed to get it to work to be honest. I've researched this throughout many points of google but stumped as to what is stopping this from working correctly.

Any insight would be greatly appreciated and to help a newbie understand this.


Thanks!!


Shawn




*Edit* When I close and reload the document, I receive a new error of 1004 - Out of Stack Space. This has got me confused even more now >,<

[cytop]

Have you protected the worksheet...?

[1337g4m3r]

Cytop,

Worksheet was protected at one point with a password, upon doing so, is where I received the errors in that same variable. I've since then removed it but still showing an error for this string, now with the 1004 error...

[Norie]

When are you running this code?

Also, which worksheet in which workbook does ActiveWorkbook.Worksheets(1) refer to?

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[cytop]

Only asked about protection because of this:

Please Login or Register  to view this content.

To which you answered

Worksheet was protected at one point with a password... since then removed it

That code, then, does not reflect the current version of your code.

[1337g4m3r]

If you are referring to this then this is what the source would be.

Please Login or Register  to view this content.

[cytop]

But the code STILL protects the sheet, then immediately tries to write to the sheet - that will throw a 1004 error.

[1337g4m3r]

I'll try to look at it to see what variations I can come up with in the code. Least that gives me a starting point to look over. Appreciate it.