Print Area:last row is variable depending on how many rows

I have a table in my sheet that is linked to SQL database. When this table is refreshed, the number of rows can grow or shorten depending on the data.
I need a macro that will set the print area from C3 to W(last row is variable depending on how many rows return from query).

Any help is GREATLY appreciated!

Hi mafiaxts4life
Welcome to the forum.
You may be able to adapt something like this to suit your needs:

Please Login or Register  to view this content.

Originally Posted by barryleajo

Hi mafiaxts4life
Welcome to the forum.
You may be able to adapt something like this to suit your needs:

Please Login or Register  to view this content.

Thanks for above....
I have data, and if F10 value is 120, print row upto 120, how?
plz. guide.......

Hi hvg88
Welcome to the forum
Please take a moment to become familiar with our rules - especially rule 2
http://www.excelforum.com/forum-rule...rum-rules.html
When you post your own thread please fully describe your requirement e.g. in your case what is the full print range that you require to print, will this be variable and so on?
Barry