I am trying to copy formula in VBA along 8 coulmns and 10 rows from the activecell.

The activecell is created from the formula finalrow = Cells(65536, 1).End(xlUp).Row - 80 because I am continully adding lines onto the worksheet and finalcolumns = Cells(8, 255).End(xlToLeft).Column

Instead of copying each line of formula and each column of formula, I woul like to know if there is a quicker way of creating a range. I have tried Range ("finalcolumn:finalrow") but this isn't right.

Can you please help

Many thanks

Becky

Rebecca

Try using the following to line of code to select the required range:

Range(Cells(StartRowVal,StartColVal), Cells(EndRowVal,EndColVal)).Select

If you are going to be reffering to this range multiple times you could create a variable for it as shown below.

Dim MyRange as Range

Set MyRange = Range(Cells(StartRowVal,StartColVal), Cells(EndRowVal,EndColVal))

Hope this helps

Carlos