I am looking to set up a Print Area on a sheet that will remain even when I delete columns. Currently my print area is A1:G24 and when I delete columns A and B, my print area becomes A1:E24. I would like to set up the print area so when columns within that range are deleted, the data that moves...
Hi All,
I am new here so if I ask a question that has been posted before please feel free to point me in the right direction.
I have reached a point in my workbook where I am going to be needing some serious help, non of this google searching, saying that it has lead me here many a time and I...
Hey Guys/Ladies,
My code currently selects a set number of Named Ranges to print.. It prints everything. Even zero totals..aaargh.
I need help getting VBA code not to print "Ranges" in worksheets where the "Total" any given table is " 0 ".
Sub PrintCDivSum()
'error trap added for...
Hello,
I wonder if anybody out there can help us out at our workplace:
every so often, we need to print work schedules from Excel, to get it right we have to:
1. Mark an area in a Excel-page
2. print that market area - vertically - adapted to one page
It's a little tiresome to do this in...
Windows 7 - Excel 10 currently but initial started it with Excel 2003- I know enough to be dangerous. I have a good size Excel application running.
I'm using modified Dom Hill, June 2008 code to Create_PDFs. The code takes all of the sheets you want to print and combines them into one PDF...
I have a list of products that I have employees use as a reference sheet to confirm they are picking the correct item # in our shipping department. The sheet is set up as
column A - item #
column B - Item name
column C - Small picture of item
column D - how to package the item
As I need to...
This code runs until this line "ActiveSheet.PageSetup.PrintArea = "A1:" & Last_Col & End_Row"
and stops. What am I doing wrong?
Sub Print_This_Analysis_Sheet()
'
' Print_Analysis_Sheet Macro
'
' Keyboard Shortcut: Ctrl+Shift+P
'
Dim Last_Col As Integer
Dim End_Row As Long
'Edit Print Area...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.