Morning!

I have a few attempts at this and I have a feeling this can work but I am missing something.

My spread sheets is a calendar filled with formulas pulling data. I want to move 1 to 4 weeks to OneNote 2010. I know I can do this with the ActivePrinter code. Though, here is the catch, I do NOT want to send the whole worksheet as this will soon be filled with hundreds of work weeks.

I had an idea to insert a Command button and add a variant to the VBA code for grabbing a cell reference as the the defined name range

Example, in cell G44 I typed in week1. I already defined this range in the spread sheet for the first work week. Then I want to add this G44 value into my code and I cannot seem to manipulate it. Also soon I would like to add in the code, if there is something in cells G44, G45, G46 and G47 to send these defined work weeks to OneNote (this can easily be done with an If Statement). Though, first thing first I need the code to work.

Here is the code (with the code to send the whole worksheet, which does work, but not needed and my 2 attempts):

Please Login or Register  to view this content.
Any suggestions will be very much appreciated.
Thank you!!
Kirsten