Apr 29, 2002 #1 lode Programmer Joined Nov 8, 2001 Messages 208 Location BE Hi, Does anybody know some VBA-code to make a printarea ? Thanks Lode.
Apr 29, 2002 #2 rmikesmith Technical User Joined Apr 29, 2002 Messages 1,215 Location US Lode, Try something like this: Code: ActiveSheet.PageSetup.PrintArea = "$A$1:$F$17" Regards, M. Smith Upvote 0 Downvote
Lode, Try something like this: Code: ActiveSheet.PageSetup.PrintArea = "$A$1:$F$17" Regards, M. Smith