Need Help on Formula For Printing
 

I used to know how to create a formula in Excel that would allow me t
print a range of cells (of my choosing) in a workbook by pressin
<CTRL <Whatever key I choose. Can someone help me? :confused

--
brickma
-----------------------------------------------------------------------
brickman's Profile: http://www.excelforum.com/member.php...fo&userid=2691
View this thread: http://www.excelforum.com/showthread.php?threadid=40137

Need Help on Formula For Printing
 

add this to a standard module

Sub print_it()
ActiveSheet.PageSetup.PrintArea = Selection.Address
ActiveWindow.SelectedSheets.PrintPreview
End Sub


assign it to a button/menu adding a ctrl + letter shortcut


"brickman" wrote:


I used to know how to create a formula in Excel that would allow me to
print a range of cells (of my choosing) in a workbook by pressing
<CTRL <Whatever key I choose. Can someone help me? :confused:


--
brickman
------------------------------------------------------------------------
brickman's Profile: http://www.excelforum.com/member.php...o&userid=26912
View this thread: http://www.excelforum.com/showthread...hreadid=401372

Need Help on Formula For Printing
 

Hi brickman,
You are probably thinking of Ctrl+P which is the same as
File, Print unlike the print toolbar button, it gives you choices,
and one of the choices is "Print Selection"..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Patrick Molloy" wrote in message
...
add this to a standard module

Sub print_it()
ActiveSheet.PageSetup.PrintArea = Selection.Address
ActiveWindow.SelectedSheets.PrintPreview
End Sub


assign it to a button/menu adding a ctrl + letter shortcut


"brickman" wrote:


I used to know how to create a formula in Excel that would allow me to
print a range of cells (of my choosing) in a workbook by pressing
<CTRL <Whatever key I choose. Can someone help me? :confused:


--
brickman
------------------------------------------------------------------------
brickman's Profile: http://www.excelforum.com/member.php...o&userid=26912
View this thread: http://www.excelforum.com/showthread...hreadid=401372