Select rows depending on selection

Once again had no idea how to title this. lol

Right.

I have a sheet with entries dated. With values next to them.

From 1/11/08 to Whenever it ends.

I would like to work out a function to select the activerow(depending on cell)
and the 30 rows under it and then print them.

Like a report almost

This could be a button or anything, no pref on it ^^

Thanks again!

try this macro

Please Login or Register  to view this content.

Try this version

It sets row 1 to be printed on each page
It sets print area the same as the 1st version
It sets page to Landscape
Prints page

Removes row 1 setting to be printed on each page
Removes the set print area
Changes page back to Portrait

Please Login or Register  to view this content.

Glad to have help solve your problem