call a macro

Hi all, I have an IF statement where I want code in a different macro executed when a cell is populated with a specific value. My code thus far is below: Sub RUNOPT() Sheets("Main Page").Select If Sheets("Main PAGE").Range("L15") = "A" Then Call RUNA If Sheets("Main PAGE").Range("L15") = "B"...

hey all does anyone see why this code won't loop to the next open workbook...? it only does it on the current workbook ive selected, and therefore, cannot Call to another macro... ideally, i would rather just have all sheets in all open workbooks autofit from columns "B:Z" but that hasn't...

I was able to get help on this forum not to long ago on a solution that worked beautifully. However, I have tried to augment the number of routines. Essentially, what I am trying to do is run a series of sort & copy/paste to another sheet. The sorts are all well defined, but the copy/paste...

I'm trying to call one macro using a macro in a different workbook. Both workbooks are open when I execute the macro. I'm using the syntax: Application.Run "MacroBook!MacroName" The error I get is Run Time Error 1004: Cannot run the macro 'macrobook!macroname' The macro may not be...

Hi, I´m having problems calling a macro. Private Sub Worksheet_Change is located in sheet1 with the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$c$5" Then Call Macro3 End If End Sub Macro3 is located in Module2 in the same workbook and works...