• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

VBA - set my print

Hello All,

I have a vba issue. I have a sheet that has several Hidden columns and Rows. How do I set the print area so that it always sets print area from cell F1 down to the visible rows? For example:
if rows (3-25) is visible, the print area is set to whatever that’s visible in range F1: K25
If row (30 – 52 ) is visible then the print area is set whatever that’s visible in range F1: K52

Thank you
R
printSet.xlsx
0
Rayne
Asked:
Rayne
1 Solution
 
RayneAuthor Commented:
Thank you Pratima :)
That works great
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now