Transpose specified number of values with VBA

Hello everyone I am stuck again with a simple problem of VBA as I am a just a novice in VBA.

I need a macro to copy 4 values i.e. from Sheet "a" range>B3:B6 and paste to sheet "b" range>>C2:F2 transposed
But I don't always require to copy 4 values...they might change to 5 or 6 or anything...so in sheet "a" cell C3 I put the number of values that are to be copied...i.e. for this example I put 4 in Sheet "a" C3..

I made a macro-

Please Login or Register  to view this content.

But this macro is only copying B3 to C2:F2
Please guide me where I am going wrong ..
I have attached the workbook...
Any help is greatly appreciated!!!

Perhaps.

Please Login or Register  to view this content.

End Sub

Norie beat me to it...

Please Login or Register  to view this content.

This works perfectly...
Thanks a lot to both of you..
I need to learn a lot still...

You are very welcome and thanks for the 'rep'