Unsure if you are able to do this.
1. Macro - Sub Test
2. Macro - Sub Test2
Within macro "Test " I'm calling macro "Test2" and passing a variable. The called macro "Test2" does what it needs to do and once completed I need to pass variables back to the main macro "Test"...
Hope you're having a great Friday!
I am running a sequence of macros as follows:
Call ClearContentsBelowRowTwo 'Macro1
Call copyDataFromMultipleWorkbooksIntoMaster 'Macro2
Call ExportOpsManPOReconExport 'Macro3
I have a series of hyperlinks on a tab that when clicked i want to hide/unhide specific rows.
I have looked around online and realize i cannot have more than one Worksheet_FollowHyperlink but that i can build a macro that calls on other macros to work around this.
i have built...
Is there a limit to how many "Call" statements you can make in a macro? I have a "Master" macro that holds the following 4 statements:
When I run the Master macro only the first two of these run. If I do a...
I am trying to create a column of hyperlinks that either 1) directs to a customer's workbook, or 2) for new customers, creates a new customer workbook and changes the active cell to make it link to their new workbook. I have a macro that completes this task, called NewCustomer, but am...
Hi all - I have been recieving some help pertaining to finding empty rows. I got the code to work:
Dim nLastrow, bFind As Range
Dim ii As Integer
For ii = 2 To 5
nLastrow = Cells(Rows.Count, 3).End(xlUp).Row
Set bFind = ActiveSheet.Range("C5:" & "C" & nLastrow).Find(What:="B" & ii...
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...
Not sure if this can be answered easily but here it goes:
I've created a module in VBA where I've placed a sub macro containing:
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
I've got a code that searches a loads database, takes the numbers and puts them into a calculator, gets a number from the calculator and then adds that factored load to another database.
To perform each of the major steps in my code, I call a function. Now when I call each function in order...
I have a private sub on "thisworkbook"
Private Sub Workbook_open()
It is a password protected wb for edit. (So if you didnt give the password when opening you can only read and can't save the file)
I want to edit this privatesub for dont run that "call"...
I am stuck on an intermediate level of VBA that I cant work out. I have a set of workbooks (Called Set B) that use some BeforeSave VBA to shrink themselves down to a more manageable size before they are saved. I have another workbook (Called Set A) that uses VBA to loop through all of...
New to VBA and this forum (thanks for having me!), but encountered a weird issue with Worksheet_Change.
So I have a protected worksheet that I unprotect when macros are running. There are 3 fields where I'm checking for changes. But I'm having an issue with cell E2 where there is...
The spreadsheet we use at my office is clunky in a number of ways. I recently joined the company, and I'm trying to clean things up for them. I dabble in Excel, but I'm no guru, which is why I need your help. We use Excel 2010.
Right now in the model, the team can look at up to 225 sites for...
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:
If Sheets("Main PAGE").Range("L15") = "A" Then Call RUNA
If Sheets("Main PAGE").Range("L15") = "B"...
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:
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
Macro3 is located in Module2 in the same workbook and works...