Help Selecting Cells with VBA When Columns Contain Different Amounts of Records

[lday75]

I have a sheet that uses 8 columns, A-H. Columns A-E contains time tracking info that I bring in from a different sheet. Columns F-H contain formulas. I am only bring over Columns A-E so there are times where Columns A-E may have say 100 rows, but Columns F-H have 80. What I am trying to do in VBA is to copy the last row of formulas in columns F-H and paste special formulas into the last 20 rows (or however many there may be at the time).

I have the following code which selects the last cell in row F that contains the formula just fine (without the :H in the range line), however as soon as I try to add the :H part I get an error Method range of object global failed. I am missing something small I know this, but nor sure what. Any help out there gurus

Please Login or Register  to view this content.

[zbor]

Try

Please Login or Register  to view this content.

[lday75]

That selects the entire sheet from the last row in H to A1, I only want to copy F-H last row with data, in my case currently I have data in range A4-E124 and in Columns F4-H111, what I want is to copy F111 - H111 and paste the formulas into F112 - H112. These row numbers will differ every time I run my other procedure which brings data into column A-E so the last row will always be different each time I run this. Hence the need to use lastrow variable

[zbor]

In that case:

Please Login or Register  to view this content.

or simplier

Please Login or Register  to view this content.

[lday75]

OFFSET.....BRILIANT thank you much, exactly what I needed.