control As IRibbonControl Unable to call

[martinez_pedro]

So I am trying to call my macro from another macro and ever since i added
control As IRibbonControl i no longer able to called from another macros
Does anyone know how to fix this problem
Thank you for your the help!!

Sub DeleteBlankRows(control As IRibbonControl)
LastRow = Cells(Cells.Rows.Count, "B").End(xlUp).Row
Range("G2:G" & LastRow).Select
On Error Resume Next
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

 

[mvptomlinson]

What is the point of adding the iRibbonControl argument as part of the macro. You don't use it and it doesn't seem necessary for the code you provided.

Also, when calling that macro from the other one, are you passing a valid control object (vs. a string value such as the name of an object)?

 

[tusharm]

You need that kind of subroutine signature only when it is a procedure that is called when a ribbon button is clicked.

So I am trying to call my macro from another macro and ever since i added
control As IRibbonControl i no longer able to called from another macros
Does anyone know how to fix this problem
Thank you for your the help!!

Sub DeleteBlankRows(control As IRibbonControl)
LastRow = Cells(Cells.Rows.Count, "B").End(xlUp).Row
Range("G2:G" & LastRow).Select
On Error Resume Next
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub