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
Convert A Form Into A Report
If there is a form that you want to to save as a report:
London & UK
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.