Run code from any page to save as PDF

[shayej]

is it possible to call the following code from any worksheet?

i get type mismatch if i call the code from any worksheet except Note. it works perfectly if i run the code when i am on Note worksheet. Thanks

Please Login or Register  to view this content.

[TMS]

Try changing Set srcWS = Sheets("Note") to Set srcWS = ActiveSheet

[TMS]

Or, maybe

Please Login or Register  to view this content.

[torachan]

does "x" have any significance in the process as it is a string in one instance and also a declared numeric variable.

[TMS]

@torachan: I suspect it is just confusing. I think the loop, using numeric variable x, is looking for an "x" in the range to flag sheets to be selected.