excel macro recording

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

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

Excel - Macro Recording with autofilling

resolvedResolved · Low Priority · Version 2003

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

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 tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

View all Excel hints and tips


Server loaded in 0.08 secs.