Range reference problem in database

[VBAnoobi]

I have written a piece of code like this...

Please Login or Register  to view this content.

Ok, so this macro builds a database, you fill the the data in range C5:C7 and then it should paste transpose it in K3 and then to K4, K5, K6 etc each time you run the macro. The problem is, that it is pasting the data to K31,K32,K33 instead of K4, K5, K6.

I know this is very noob but i really need help asap.
Thx

[Palmetto]

Forum rules require code tags when posting VBA code.
Please edit your post to add the tags.

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Please Login or Register  to view this content.

[MarvinP]

Or how about,

Please Login or Register  to view this content.

[VBAnoobi]

Thanks ppl, i got this right.