Print a small range at the top of the page

@ klvaughnsd

Thanks for your suggestion but in that particular sheet i have more than 20 different print ranges, so will be difficult to use this.

@ AlphaFrog

Thank you. This works great. I'll mark thread as solved but can you pls tell me:

1) If i want range BK11:BK12 to be printed at the right side of the report will i use this?

 ..PageSetup.RightHeader

2) Range BK11:BK12 is bolded and have a border arount but these are not printed. Can we do something for that?

Again thank you very much!