Originally posted by royUK
First suggestion would be to try recording your macros with the Macro Recorder, that way you can get an idea of what is required.
I tought about that to, but the problem is that I don't know how to ask the user for input as to how many times the specific column should be copied.
Are you looking to copy the complete columns, because you also mention rows?
Well, not the entire colomn but just a the cells between row x and row y.