98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Macro Recording with autofilling
Excel - Macro Recording with autofilling
Resolved · 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting blank cells within a range of dataSelect 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. |