Hi All,
5 minutes ago, the following code gave a print preview of any area I selected on the worksheet but now I get a compile error.
I'm pretty sure I didn't alter it but I have been working on other macros so does anyone have any ideas?
Please Login or Register to view this content.
what's the error message and on which line?
Josie
if at first you don't succeed try doing it the way your wife told you to
Compile Error: Expected Function or variable
On the Selection.PrintPreview line
have you created a routine or module called selection or printpreview?
I don't think so. I just wanted to select a bunch of cells and then do a print preview on them...which is what this code did earlier.
Is there any way of finding out and/or exiting from that module or routine at the beginning of this macro so it works properly?
I am such a doofus...my most recent macro is called Selection!
Thank you for pointing me in the right direction.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks