Find last row with data

[rollingzep]

Hi,

I import data from a large text file daily with over 200,000 rows to a workbook, WB1. In my VBA code, I import all the fields and then delete the fields and format them.
Of the 30 odd fields, I finally get the data on the 3 columns, This Workbook, i use for the backend data. On column F, G and H, I have 150 rows of saved data, which are
constant and which I copy and add to the imported rows, A, B and C manually.
is there a way to do this via code? I need to copy and paste this data after the last identified row of Col A.

I know to derive the last row containing data, using Range("A" & Rows.Count).End(xlUp).EntireRow.Select.
How to identify the next row to this last row and add data from cols, G to H?

TIA

 

[Joe4]

OK, try this:

    Range("F1:H150").Copy Range("A" & Rows.Count).End(xlUp).Offset(1, 0)

 

[rollingzep]

OK, try this:

    Range("F1:H150").Copy Range("A" & Rows.Count).End(xlUp).Offset(1, 0)

Thank you

 

[Joe4]

You are welcome.