Can not create the correct code for Macro to paste to blank column

[Elvis1960]

I am stuck. I am trying to create a macro to do the following:

Copy range C6:C14
Paste this range to the second empty column of the same worksheet at the same starting row.
It will always copy the same range but will need to paste to new columns based on which columns are empty.

Thanks for the help in advance.

[jwright650]

Do you have an example workbook that you can attach? Not sure what you have wrong with your macro...need to post a file or something to tinker with

[Elvis1960]

Here is the code that I have but it does not work. I want the macro to copy the range then find the next empty column +1 and paste the date starting on the same row.

Code:

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 04/07/2011'

'
Range("B5:D20").Select
Range("B20").Activate
Selection.Copy
Range("A" & Rows.Count).End(xlUp).Row4
Cells(2, Columns.Count).End(xlToLeft).Column10 1
ActiveSheet.Paste
Range("G14").Select
End Sub


End Code.