VBA Macro's in Excel

Resolved · Low Priority · Version 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:

Renaming or Deleting Files when Saving or Opening

You can rename and delete files any time you are using a FILE > OPEN or a FILE > SAVE dialog box.
When you see the list of files when browsing in the current folder, you can treat is just like the windows explorer window, by selecting and then editing.

To rename, just give the file a single click to select, then a second to enter the file name. Type the name you want, and press enter.

To delete, a single click and hit the delete key.

View all Microsoft Office hints and tips

VBA Macro's in Excel

VBA Macro's in Excel

RE: VBA Macro's in Excel

Microsoft Office articles

Microsoft Office tip:

Renaming or Deleting Files when Saving or Opening