Hi,
I am using this macro to print selected sheets from a workbook with 229 sheets.
It should only print the sheets with qualifying data in two specific cells. It worked perfectly for about 2 weeks. I went home on Tuesday and everything was fine, came back on Thursday and I am getting a runtime 13 miss match error.
Any thoughts?
Thank you
Please Login or Register to view this content.
Last edited by joleen; 06-05-2011 at 06:27 AM. Reason: Solved
Why did you go home in the first place .... ?
I'd try:
Please Login or Register to view this content.
Last edited by snb; 06-04-2011 at 08:58 AM.
If you click Debug when the error message appears, which line of the code is highlighted?
The line that is highlighted is:
Please Login or Register to view this content.
I tried the new code. Thank you snb,
But I am still receiving the same error.
Last edited by joleen; 06-04-2011 at 08:53 AM. Reason: to clarify what post I was responding to
I don't think my suggestion will produce that error.
is the culprit.Please Login or Register to view this content.
@snb
apparently it does. Otherwise the asker would not report it. Instead of tagging the componentI don't think my suggestion will produce that error.
as "the culprit", do you have a suggestion about how to troubleshoot the issue?Please Login or Register to view this content.
I am using a the E1 cell on each sheet to reflect dates in cell A4 as just a number. When I had
I always ended up with sheets printed out where A4 was empty.Please Login or Register to view this content.
I don't know if that helps at all.
Please Login or Register to view this content.
Last edited by snb; 06-04-2011 at 10:11 AM.
With
I receive a Runtime error '438' Object does not support this property or method.Please Login or Register to view this content.
And still the line highlighted by the debugger is basically the same.
This file is moved back and forth from a sharepoint site everyday. Could that be causing corruption problems?Please Login or Register to view this content.
Has anything in the cells that are checked been changed? This might be on just one sheet
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I did a full manual check and yes actual a lot had changed.
1) On almost all of the sheets cell A1 was "blank" instead of "empty" so instead of showing a zero in E1 it was blank
2)I found a whole bunch of sheets were the formating had been changed from General to a custom date.
3) There was one sheet where instead of E1 referencing A4 it had a REF# error.
My guess is on my days off my co-worker cleared the data by deleting the whole row and not just contents of the cells.
Everything is working now.
Thank you so much for your help.
Now if I can just figure out how to keep the empty cells empty I'll be in great shape.
Have you used sheet protection to lock cells?
I have locked most of the cells in the workbook. However I haven't locked anything that needs to have manual data entry. I was under the impression that there is no way to prevent a cell from being deleted and still have it open for data adjustment.
You might be able to protect the workbook structure using Workbook Protection.
Naturally, make sure you have a back up file at all times
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks