VBA Code to Copy and Paste Data into first empty cell in Column A

[bdhopp]

Hello:

I'm trying to copy two cell ranges in an active workbook and paste
them into the first empty cell in Column A of another workbook entitled "June Time Log Book."

The cell ranges in question are ("C6:C26,G6:G26"). I would really appreciate some answers on how to accomplish this. Thanks!

 

[VoG]

Possibly

Range("C6:C26,G6:G26").Copy Destination:=Workbooks("June Time Log Book.xls").Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Offset(1)

 

[Smitty]

Welcome to the Board!

Please continue in your Original Thread.

It helps keep everyone on track and prevents duplication of efforts.