access vba courses - VBA Formula copying
Resolved · Low Priority · Version Standard
Rebecca has attended:
Excel Advanced course
VBA Formula copying
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
For upcoming training course dates see: Pricing & availability
RE: VBA Formula copying
Try using the following to line of code to select the required range:
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