Hello everyone,
I have enjoyed reading all the numerous helpful tips and hints that everyone has given. I have an issue, probably a simple one for the geniuses on here. I am trying to do a macro in Excel 2010 that will take a range from A1:E8 on Sheet1, have a message box ask how many times to copy, and then copy and paste that range however many times I tell it to, including the formulas, onto sheet2. Can someone offer me some assistance? Thank you in advance.
I have enjoyed reading all the numerous helpful tips and hints that everyone has given. I have an issue, probably a simple one for the geniuses on here. I am trying to do a macro in Excel 2010 that will take a range from A1:E8 on Sheet1, have a message box ask how many times to copy, and then copy and paste that range however many times I tell it to, including the formulas, onto sheet2. Can someone offer me some assistance? Thank you in advance.