You can declare it, or you can remove it

remove the line
vVal = wsSheet.PageSetup.Zoom





--
Regards,
Tom Ogilvy

"Phil Hageman" wrote in message
...
Tom,

I copied this latest into the ThisWorkbook module (Option Explicit is set)
and received a compile error: Variable not defined. Highlighted is: vVal =

Thanks, and I appreciate what you are trying to do for me.

Phil