macro function

  1. J

    Selected Sheet Hidden; ERROR can't run macro

    I have several sheets that need to have an application run, but only if it is not hidden. This is what I currently have and the macro stops to debug when it the sheetX is hidden. Sheet5.Select Application.Run _ "'Program Spend Statement - Master Template.xls'!RemoveAndClear"...
  2. A

    Is It Possible to Call a Macro from a Function?

    I created a macro (Sub Macro6()) that I want to call like a function on my spreadsheet, is it possible to call a macro from a function? I didn't program the macro manually, I used menu options to record it. But I'd like to be able to use it like a function. The macro does exactly what I need it...

Some videos you may like

This Week's Hot Topics