Paste Range Down to Last Row

[bluemanuk1]

Hi,

I am trying to copy a range of cells down that has formulas in them but when recording the macro is keeps the last row pasted to. I need to make it dynamic.

Data in columns B to H could be 10 rows long or 20 or 50. The formulas Cells I2 to O2 need to be copied to the last row used in column B and then copied ready for use elsewhere.

The crucial bit is needs to pasting of I2 to O2 to be down to last column used in B.

I have attached the test file.

Hope someone can help. Thanks in advance.

[Joske920]

hi,

Give this a try, copy it to the sheet code area not a module

Please Login or Register  to view this content.

[bluemanuk1]

Thank you ,this worked nicely.