I hope someone can help.
I have a spreadsheet (don't we all) that contains X number of rows, on the sheet I want to have a single button to extract the rows as .csv.
In essence what I want to happen when the button is clicked is for Macro A to run if there are less than X rows and Macro B to run if there are X rows or more. In my instance X will be 2.
Obvoiously this is easy of one uses 2 buttons but that isn't neat enough for my solution.
Cheers,
Matt
I have a spreadsheet (don't we all) that contains X number of rows, on the sheet I want to have a single button to extract the rows as .csv.
In essence what I want to happen when the button is clicked is for Macro A to run if there are less than X rows and Macro B to run if there are X rows or more. In my instance X will be 2.
Obvoiously this is easy of one uses 2 buttons but that isn't neat enough for my solution.
Cheers,
Matt