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

Excel - Macro Recording with autofilling

ResolvedVersion 2003

Fri 24 Oct 2008, 15:57 Delegate 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

Thu 6 Nov 2008, 09:48 Trainer 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

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips

Excel - Macro Recording with autofilling

Excel - Macro Recording with autofilling

RE: Excel - Macro Recording with autofilling

Excel articles

Excel tip:

Convert a column into row quickly in Excel 2010