call macro

Hello, I'm trying to call a Sub which I created in a module into a worksheet. The idea is to create multiple modules which I can call in this worksheet where the module is applying on. This are the codes I use right now. Module 1 Private Sub Trap() If Intersect(Range("C31"), Target) Is...

Hi there, I have several macros which have been written individually which run simple formulas and return the data to the active column. Eg. Macro 1 enters a simple formula in cell X2, to return the result, whereby column X is the first blank column at the end of my dataset. To avoid running...

Hi, I have written a macro which calls another macro (called 'Step1'). Unfortunately, 'Step1' is locked by my company so I cannot review or edit it. When 'Step1' is called, it requires a string to be entered into an input box. Is there any way I can send a string from my macro to fill this...

Hello, I have a sub that calls multiple other macros that mainly hide, clear and adjust rows as well as copy paste certain areas to others. Sub Hide_And_Adjust() Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.DisplayStatusBar = False...

I have a macro in spreadsheet "A" that opens Spreadsheet "B" I need to run a macro within spreadsheet "B" The catch is that I need to pass a parameter to the macro The macro is called AddUnits and you need to pass a number to it I tried both 1) Application.Run = "'" + ActiveWorkbook.Name +...

Hi. I'm trying to call a macro using a Worksheet_Change Event but everytime I run it nothing happens. The event itself works great and recognized that the macro doesn't exist after I tried deleting it. I've also tried testing my macro using the Immediate Window feature and everything worked as...

Hi, I have a super macro that is giving fits and I'm not seeing why. It is made of macros that call other macros (all of which work correctly on their own). The SuperMacro needs to run from one workbook that opens other workbooks and activate their macros. SuperMacro and one of its nested...

Hi, I have a query regarding my code. I am not sure why am I getting this error when I am calling another macro. I found out that when I am at the MasterData sheet macro works fine. I suspect it there is some discrepancy with the find function and I like to know why. The highlighted debug...

Hello, I wonder if anyone can advise on if the following is possible? I have a sheet with various weeks' data, and there is a small macro to sort by week for each week in the sheet. So there are macros: sort1, sort2, sort3, sort4 etc. What I would like to do is call the relative macro within...

Hi All, I'm new to this so please forgive my ignorance. I am trying to format a graph axis on the basis of the data in a cell which is calculated by formula. To do this I have created one macro (which I have tested) which I intend to reference in the worksheet_calculate() function as below...

Hello All, Here is a VBA batch project I am working on. I have 45 .Xlsm files • Each have a Macro to Unlock the file Unlock_File • Each have a named Range QtrComment which equals a quarter and date "Q3 2014" •Each have a Macro that Locks the file back down and Saves the File Lock_File...

Hi All, I am getting he Subscript out of range error when trying to run this macro. I have the macro on a macro workbook and I am referencing another spreadsheet. any help would be appreciated. Sub Dater() Static Count As Integer Dim Wb As Workbook Dim Ws As Worksheet Dim...

Hello Friends. I'm looking for a way/code to automatically select the cells in Column 2 that have the same page number associated with them in Column 1. Then I want to call a macro and then repeat the process. I have provided the link for the 15kb macro enabled excel file with which I need help...

I need a macro that will check to see if Sheet 3 has been updated or new data entered. If updated, show a message box asking “Would you like to reorganize sheet now?” Yes or No. If Yes, run/call macro “Reorganize()”. If “No” Cancel. Thanks so much, -Tmoske

Hello, I have created the following "GetResult" VBA macro within Excel to apply a custom formula to the value of a given source cell within a hidden sheet, and display the result in a target cell on a visible target sheet: Sub GetResult(SourceCell as String)...

Hello all, What I am working on - I have a Master file that will open another workbook based on a list and the newly opened file will have a hyperlink on Cell ("C14") when you manually click the cell it Calls Macro1*. The problem I am having is in my research for this process I found this...

Hi, I am new to VBA, and have written some simple code that pulls some information out of a SharePoint 2010 list view, and makes some simple calculations within an Excel 2010 table. I have then written a number of individual subs that use the table to prepare a single Pivot Table each. The...