Hi.
I typed the following code
When i type: = RunMacro("noclr"), it excute macro "noclr" and shows the MsgBox
But when i type: = RunMacro("clrows"), it do nothing, and the coulom "D" not cleared
How can I adjust the code so that execeute macro "clrows"
I typed the following code
Code:
Function RunMacro(FunctionName As String)
Application.Run FunctionName
RunMacro = ""
End Function
Sub noclr()
MsgBox "Nothing to clear"
End Sub
Sub clrows()
Sheets("Sheet1").Range("B:B").ClearContents
End Sub
But when i type: = RunMacro("clrows"), it do nothing, and the coulom "D" not cleared
How can I adjust the code so that execeute macro "clrows"