see my response in microsoft.public.excel.misc

it is not necessary to post to multiple groups ... it can fragment your
answers and upset people who may spend quite a bit of time coming up with an
answer only to discover that someone else answered the question in another
group.

Cheers
JulieD

"Anthony" wrote in message
...
Here is one for you experts - I am a novice

I want to add a macro to a worksheet that will print selected information
held on certain rows of the worksheet.
Once the 'button' has been selected a mesage box will pop up asking the
user
to input which row number he/she wishes to print.
On input that number is matched to the corresponding row of the worksheet
and that row is copied (without any formula - just cell values) and pasted
into another worksheet where it is placed into other formats and printed.

Seems like a simple(!!) job - but far to difficult for me to programme

Can anybody offer some VB script??

Many thanks in advance

Anthony