Forum Discussion
Need help writing a macro to copy a cell formula down a column
I'm an older guy, 70s, who needs help writing an Excel VBA macro. I have a sheet with a standard set of columns, but the rows are variable, anywhere from 250 to 25,000. My goal is to copy an IF state...
Given the information you have provided to date, it is not obvious to me that you do require a VBA macro. For example, the IF statement would copy down automatically if you were to convert the data range into an Excel Table.
It would be a different situation if you already perform the data analysis using VBA. Even then, the 'copy down' you describe is a manual process which could be replicated using VBA formulas but could also be better achieved by identifying the range and applying the formula to the entire range as its .formula property as a single step (no copying required).