Hi Any assistance with the following would be most welcome.
I am trying to find some VBA code which will allow me to copy a formula from an ActiveCell down to the last row in the ActiveCell column based on the non blank cells in the column to the left of the ActiveCell column. For example, if the ActiveCell is equal to C5 and the range B5 to B20 contains entries. I would like to autofill the formula from cell C5 down to C20. To further complicate matters, the ActiveCell may be in column C in one instance and in another it could be column D etc (in other words, it can be in any column depending on the source data). The column to the immediate left will always have entries in it but the number of rows will change as well. Thanks, Steve PS I am using Microsoft Office 2003 with windows XP -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
