Predefined Print area based on variable

  • Thread starter Thread starter CorporateQAinTX
  • Start date Start date
C

CorporateQAinTX

Here's what I've got...I have a sheet 60 cells wide broken into increments of
4 for a total of 15 sections. Each section correlates to a number in cell C2.
If I place a 4 in C2 I would like excel to print only through section 4. I'd
like to get away with this with no VBA code. I'm not sure any future
personnel who may get this position will know how to edit it if need be. I've
tried coding a nested If statement into the PrintArea block, but it won't
take code there. Any suggestions.
 
Without VBA you could set up some Custom Views and have your users select from
those.

Drag the Custom Views Icon to your Toolbar to make it simple for the users.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

variable print area? 4
Dynanic Print Range 2
Use variable for a range in WITH block 2
Print from Option Buttons 2
Need macro that transforms key words into predefined numbers 2
Print sheets based on cell value 1
How to compare the max width of a cell compared to the max width of awksht page? 1
Print Area propery 1

Back
Top