Hide Selected Rows

[RJ1969]

Hi All,
I would like to add a code in the vba codes below to hide a selected rows in a worksheet Sheet2. Let say Row 32:41, Row 70:80 and Row 90:99.

Thanks

Please Login or Register  to view this content.

[Arkadi]

Please Login or Register  to view this content.

will hide rows that have cells selected.

[RJ1969]

Hi
Don't I supposed to indicate what rows I needed to hide. I don't need the entire row to be hidden.
these are the only row that I want to hide so It does no show in the printview.

Row 32:41, Row 70:80 and Row 90:99

Thanks.

[Arkadi]

You specified "selected rows" so I assumed they were selected... and you can't hide partial row...

Please Login or Register  to view this content.

[RJ1969]

Thank you but so Sorry, I probably did not clarify what I was trying to accomplish here. I apologize.

What I was trying is that when I print the worksheet Sheet2, I don't want to include those row 32:41, and 70:80, and 90:99 to print.

This is what I added in the code which works.

Please Login or Register  to view this content.

Please see the attachment sample worksheet.

[Arkadi]

That is the same as my last post I believe, except I didn't know you wanted to hard-code the row numbers, and thought you wanted to be able to select them, however, I'm glad that you have it worked out
I did unhide the rows in my code after print preview, to put it back to normal... which means if you printed manually after the macro finished, those rows would print. You could always add a .Printout command before unhiding, or leave them hidden by removing the .Hidden = False line.

If your issue is resolved then please mark the thread as solved.

[RJ1969]

Hi Arkadi,
I am sorry I don't really understand. My English is not that good and not good with the VBA as well.

What I want to do is not to print those row when I printed the worksheet.

I don't understand this part:
You could always add a .Printout command before unhiding, or leave them hidden by removing the .Hidden = False line.

Thanks.

[Arkadi]

Ok... is your problem fixed? Or no?
Do you want to choose rows to not print during macro? Or always same?

[RJ1969]

Hi
Not fixed.
I want rows to choose not to print.

Thanks

[RJ1969]

addition, Not always the same