Attach a macro to a print button that will print a certain row on my sheet

[neen149]

Hello,
I am completely new to VB.
This is what I want to do: I would like to have a print button on my sheet that will print only one row. The macro could request which row from a drop down or print just the row selected. Any help would be appreciated.

Thanks
Geraldine

[jolivanes]

Please Login or Register  to view this content.

Or if you want to give it a Row Number.

Please Login or Register  to view this content.

[jolivanes]

Or you can do it this way also.
Enough possibilities?

[neen149]

Thanks so much

[jolivanes]

Thanks for letting us know and have a good weekend.
Stay safe

[BrunoCampanini]

Please Login or Register  to view this content.

[jolivanes]

@ Bruno
I hope that they have a printer with +/- 2000 sheets of paper in it if they happen to run your suggestion with the ActiveCell to the right of the used range.

[BrunoCampanini]

Well I missed to say the ActiveCell must exclude the the extreme ones of the line range.

I want to print the line H10:Q10 (of course the definition implies H9 and Q11 are blank cells, otherwise H10:Q10 is not a line but only a portion of a line).
The ActiveCell must be in the range H11:Q9.

Is that clear enough?

What is the function of a Forum Expert:
to be constructive or argumentative?

[jolivanes]

It's called "tongue in cheek", in other words "jokingly"
If I offended you, my apologies.

[BrunoCampanini]

Saying the truth you can offend only a stupid man.
I don't estimate me a stupid man, then you didn't offend me.

It was the same for me: just joking.

Ciao

[jolivanes]

All is well then.
Stay safe

[neen149]

Hello,
How would I get the one row to print as two lines. I find that the print is small as it is printing on a 3.5x2.5 sticker.

Thanks

[jolivanes]

@neen149
Please read the forum rules. #4 Comes to mind.

[neen149]

My apologies I will post new