Question How can I make an Excel Macro do these steps? 1.Get the macro to move to a particular cell (the Range statement) 2. Fill that cell with a value 3. Store the value in a variable (call it x) 4. Move to the top of an empty column 5. Set up a loop to fill the column with x occurrences of your name 6. Fit the column width to the text (Autofit) 7. Get the macro to ask whether you would like to run again 8. Set up a statement which will go back to the start if you answer Yes
Question
How can I make an Excel Macro do these steps?1.Get the macro to move to a particular cell (the Range
statement)
2. Fill that cell with a value
3. Store the value in a variable (call it x)
4. Move to the top of an empty column
5. Set up a loop to fill the column with x occurrences of your name
6. Fit the column width to the text (Autofit)
7. Get the macro to ask whether you would like to run again
8. Set up a statement which will go back to the start if you answer Yes