VBA Problem - Pasting and Offsets - Layout Trouble.

Please Login or Register  to view this content.

is my macro....

This is the result.

\1

what i want to do is described in the picture, even my ict teacher cant get it to work ¬_¬ i was ment to start testing on monday, and i cant get this bit finished.

Thanks

Remove the red font in the below code:

Please Login or Register  to view this content.

Then it looks like you are also trying to paste it starting in column A. To change this, try changing:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

The problem is because your activecell is in column A and you are not offsetting when pasting

I have modified the code to merge some commands and to remove some commands that were not required

In the code when pasting I was not sure if it needed to offset by 1 row & 1 column or just 1 column - I offset the row & column

Please Login or Register  to view this content.

Thanks a ton! youve saved my *** with this project :D