98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » access vba courses - VBA Formula copying
access vba courses - VBA Formula copying
Resolved · Low Priority · Version Standard
Wed 21 Nov 2007, 16:21Delegate Rebecca said...
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
Many thanks
Becky
Fri 23 Nov 2007, 15:21Trainer Carlos said...
RE: VBA Formula copying
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Splittng a databaseSplit your database into two (at least). |
