I am a beginner in writing macros and will greatly appreciate assistance in the following:
I am Printing To File and have the name of the file to be printed contained in the Active Sheet at cell B47 in text format, every time I print, I am prompted to enter the file name, how do I set it to automatically apply
the name contained in cell B47
I also print different areas of the Active Sheet when calling the print Sub.
How do I place the Range to be printed which is specified by the content of cell B48 in text format and located in the Active Sheet, and place it into the ActiveSheet.PageSetup.PrintArea =
(i.e. Cell B48 contains A10:Y80 in text format I could also place into B48 the text $A$10:$Y$80)
Thanks in advane to anyone who could assist.
Sub PrintSA()
'
ActiveSheet.PageSetup.PrintArea = "$A$10:$Y$80"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
I am Printing To File and have the name of the file to be printed contained in the Active Sheet at cell B47 in text format, every time I print, I am prompted to enter the file name, how do I set it to automatically apply
the name contained in cell B47
I also print different areas of the Active Sheet when calling the print Sub.
How do I place the Range to be printed which is specified by the content of cell B48 in text format and located in the Active Sheet, and place it into the ActiveSheet.PageSetup.PrintArea =
(i.e. Cell B48 contains A10:Y80 in text format I could also place into B48 the text $A$10:$Y$80)
Thanks in advane to anyone who could assist.
Sub PrintSA()
'
ActiveSheet.PageSetup.PrintArea = "$A$10:$Y$80"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub