VBA Send one specific sheet in PDF (based on one cell)

[scoclu]

Hello!
VBA code is almost working! Need your help please to send one specific sheet in PDF.
Selected sheet to be send is in L6.

VBA Code is set with Sheet4

Please Login or Register  to view this content.

It should be something like:

Please Login or Register  to view this content.

but it's not working.... help please!

Many thanks!

[davesexcel]

I believe it would be something like

Please Login or Register  to view this content.

[scoclu]

Amazing! Thanks Davesexcel! it's working!