Set print area by counting 6 rows, skip words when counting

wherbjr35

New Member
Joined
Nov 2, 2004
Messages
19
Sound crazy enough??

I am trying to figure out how to set my print area to give me a 6 week calendar. So ideally, I would like to see this in my print area:

January 2005 (skip when counting)
Row1
Row2
Row3
Row4
February 2005 (skip when counting)
Row5
Row6

So far I have this, which just sets a static range of cells in the print area.

Sub Macro1
Range("A1:H11").Select
ActiveSheet.PageSetup.PrintArea = "$B$1:$H$6"
End Sub

I need to add a place where a cell search will look for "January 2005", 'Febuary 2005", etc, and skip over that row is it count to 6 rows (weeks on calendars)

ANY thoughts would be appreciated.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,214,639
Messages
6,120,679
Members
448,977
Latest member
dbonilla0331

We've detected that you are using an adblocker.

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.
Go back
Back
Top