I have a sheet that I need to set the print area on based on a count of the rows (there is only one column to be printed)
My row count is in cell B1
The data to be printed is in A1:A(value of B1)
Can a Macro do this or VBA..?
I have an active refreshing excel chart that we run on a big seconary monitor to show stats for the day. Problem is when someone wants to use excel normally it opens on the big screen when I want it on the standard display. Is there a way to default the chart to the secondary monitor by default...