Can only get page to print properly if I press enter within the worksheet being printed.

[ecorf]

I have a workbook that contains over 20 worksheets (I have dummed it down for the test files that are attached).

In the QC worksheet (tab), In Column C (Range 5:1444), the user will enter comments as needed. Then, in the C-Build worksheet, those comments are stacked. The resulting report is located in the Comments worksheet.

The attached Macro will print out the Comments page to a pdf.

After manually changing comments in Column C in QC Worksheet, the Comments page looks right.

However, unless I do this -the printout will not work: IF I press ENTER in any unused cell (say in column G) of the Comments worksheet, then SAVE. It prints fine.

If you don't press ENTER in an unused cell in Comments worksheet, then the pdf only prints the first line of comments.

I tried adding SENDKEY in the macro but never could get that to work.

Of course, the workaround will be just to notify the user he/she will just need to go to the Comments tab and press ENTER in one of the cells (not in A:C).

Any thoughts?

Thanks!

Please Login or Register  to view this content.

I have attaced the MACRO (only use STEP 4, after changing your paths as mentioned in the macro example). Also, the QC Spreadsheet and 2 png examples of a good and bad printout.

[TMS]

This runs through, from end to end, and produces the .pdf file without selecting anything in the Comments worksheet.

The problem was that the workbook and worksheets needed to be qualified to ensure the right workbook, sheet and range were being used to determine the last row. "Pressing enter on an unused cell" actually caused the Comment sheet to be the active sheet. This, in turn, meant the last row was calculated based on data in column C on the Comments sheet. Without that intervention, the last row would have been calculated based on the data on whatever sheet was active when the source workbook was saved, whic I suspect was RAW.

Please Login or Register  to view this content.

[ecorf]

Wow TMS! That did the trick. This stuff can be very complicated. So glad there's great people on this forum to help us novices out. Thank you so much!

[TMS]

You're welcome. Thanks for the rep.