subroutine call

Hey guys, I am working on a workbook that is connected to a server. (The Check-In and Check-Out features are enabled) Is there a way to run a few macros in the event that someone checks the file back in? Initially I was using something like this to run some routines when the workbook was...

I have the following 2 subroutines and I'm getting a runtime error "object required" when I am calling "renamesecurities". I think the problem is coming from which Sub i need to define the variables in, but am not sure. Maybe the problem is I need to define more variables? Sub format() '...

I have a couple subs that call other subs that do not show up in the macro table. I guess because the sub simply contains arguments??? I would like to assign this to a button. Anyone know how I can get it to show up in the macro table? ****************************** Sub RunSolvers() If Not...

I have one subroutine that calls many other subroutines based on a number of buttons/conditions I've set up in my Excel worksheet. Below is a truncated example of this. Public a as Integer Public ans as Integer Public Sub StartingMacro() If Application.Caller = "button1" Then Call Macro1...

All, I am not a programmer. But, I need a little programming help. I created an Excel Macro. I need the first Macro (Name_IP) to call another Subroutine/Excel Macro (IPSplitAddresses). When I use test data and the IPSplitAddresses as a Stand Alone Excel Macro/Subrountine, the...

Hi all. I would like to call a subroutine only if a cell on the active sheet is not empty. So far I have tried the following: Range("A2").Select If R1C1 <> """" Then Call Subroutinename If A2 <> """" Then Call Subroutiename If LEN(R1C1) > 0 Then Call Subroutinename None of them work...

Hi, I am a noob in VBA, and this is the first time i am trying to use VBA for charting. I have 5 sheets, with 32 to 34 rows of data. For each row of data, on a separate sheet, I have calculated the minimum & maximum value, to be used set the chart Axis scale. The tables used for building the...

In Excel VBA, if subroutine A calls subroutine B, is there a way for subroutine B to know that subroutine A was what called it? I mean this for run-time, so not talking about watch window. Application.caller seems to give info in calling VBA from Excel, not for info about a subroutine calling...