Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Macro Recording with autofilling

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel - Macro Recording with autofilling

Resolved · Low Priority · Version 2003

Reply Fri 24 Oct 2008, 15:57Delegate Vignesh said...

Vignesh has attended:
Access Intermediate course

Excel - Macro Recording with autofilling

How can you autofill a column so that it gets recorded in a macro properly? I used the double click function, but the resulting macro only took the range. If I were to then run the macro on a longer sheet, it wouldn't fill for all the values.

I could probably work it out via VB code, but it would be nice to know the way to do it via the Macro Recorder.

Regards,

Vignesh

For upcoming training course dates see: Pricing & availability

Reply Thu 6 Nov 2008, 09:48Trainer Amanda said...

RE: Excel - Macro Recording with autofilling

Hello Vignesh

Thank you for your question and welcome to the forum.

As far as I know, this would need to be done using VB code - I don't think you would be able to do this using the macro recorder.

Kind regards
Amanda

Excel articles

· How To Use The Cell Styles Functionality In Excel 2010
· Experience The Power Of PowerPivot
· Customized Financial Excel Courses in London
· Data Basics Using Excel
· Unsupported features in Excel 2007

Please browse our web site to find out more about
training excel vba and other Microsoft training courses.

Excel tip:

Pivot table grouping

If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips