skarnik01
Member
Hi,
I am trying to create a file wherein
1. On running a macro, it asks me to select a data range
2. On confirming the range (ideally through an OK button), the macro records the maximum, minimum values as well as the last cell value in the range
3. In case, I click on Cancel, there should be no change in the file
4. When I re-run the macro, it should allow me to change the range and thereby allow changes in the earlier values recorded
I am attaching the file with data in it. I intend to select a range between columns B - D with multiple rows
For instance if I select the range B5:D11 in the sheet 'Data', the Macro should help me store the values in the sheet 'Stats' as:
Max: 5332
Min: 213
Last: 432
Thank you in advance
I am trying to create a file wherein
1. On running a macro, it asks me to select a data range
2. On confirming the range (ideally through an OK button), the macro records the maximum, minimum values as well as the last cell value in the range
3. In case, I click on Cancel, there should be no change in the file
4. When I re-run the macro, it should allow me to change the range and thereby allow changes in the earlier values recorded
I am attaching the file with data in it. I intend to select a range between columns B - D with multiple rows
For instance if I select the range B5:D11 in the sheet 'Data', the Macro should help me store the values in the sheet 'Stats' as:
Max: 5332
Min: 213
Last: 432
Thank you in advance
