access vba courses - vba formula copying


starstarstarstarstar Excellent

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

resolvedResolved · Low Priority · Version Standard

Wed 21 Nov 2007, 16:21 replyReply Delegate 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


For upcoming training course dates see: Pricing & availability

Fri 23 Nov 2007, 15:21 replyReply Trainer Carlos said...

RE: VBA Formula copying


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



Live dates & prices


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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips