Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Office general help » VBA Macro's in Excel

VBA Macro's in Excel

ResolvedVersion 2007

Tue 20 Sep 2011, 09:29 Delegate Richard said...

Richard has attended:
Windows Introduction course

VBA Macro's in Excel

How would I create a macro to copy a range of data (within a pivot) that is refreshed each month that is not the same number of rows each month? unless the copy matches the row count within the macro the formatting is lost.

Sat 24 Sep 2011, 12:37 Trainer Anthony said...

RE: VBA Macro's in Excel

Hi Richard, thanks for your query. You'll need to use a dynamic named range to do that. More information here:

http://www.ozgrid.com/Excel/DynamicRanges.htm

Hope this helps,

Anthony

Sat 1 Oct 2011: Automatically marked as resolved.

Microsoft Office tip:

Standard Function Keys

Function keys are quick ways of completing certain operations in software packages, but tend to vary from package to package.

3 standard Windows ones - F1 Help, F2 Edit, F5 GoTo.

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

VBA Macro's in Excel

VBA Macro's in Excel

RE: VBA Macro's in Excel

Microsoft Office articles

Microsoft Office tip:

Standard Function Keys