Run One Macro or Another From Worksheet Button

[SSP]

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

 

[Norie]

Matt

Why do you need 2 macros?

Why not just check for the number of rows in the command button click event and then act accordingly?

 

[Datsmart]

Hi Matt,

Welcome to the board.

Here is a suggestion to use your two macros:

Sub RowCheck()
    LastRow = Cells(Rows.Count, 1).End(xlUp).Row
    If LastRow < 2 Then
        Call MacroA
    Else
        Call MacroB
    End If
End Sub

You can assign this code to your existing button, or, as Norie suggests, incorporate checking the row count and your macros "A" and "B", into the button's event code.

 

[SSP]

Many thanks for the suggestions I'l give both a try to increase my knowledge.

Cheers,

Matt