run a macro

Hi all, Hope you are well. I am trying to create a VBA macro that saves or exports a pdf file based on a range that populates a sheet based on the cell value captured. Each cell in said range contains an IF formula. I have gathered a few different scripts to come up with a macro to identify non...

I am trying to handle an error in a macro from another workbook, but on error is not working within any error occurring in the macro from another workbook when I use application.run. Anyone know why it is not working and how to solve this? Set wb = Workbooks.Open(workbookpath) On...

Hi, I have a formatting macro below: Sub Colour_whole_sheet() Dim lastRow As Long Dim lastColumn As Long lastRow = Range("A1").End(xlDown).Row lastColumn = Range("A3").End(xlToRight).Column 'Colour alternate rows purple / white For Each cell In Range(Cells(1, 1), Cells(lastRow...

I want one macro to run several other macros, but when I write the code, I receive a compile error - sub or function not defined. What am I missing? Sub Runallmacros() Call LYRates Call TYRates Call DeleteSpaces End Sub

Hello everyone i have simple vba code to find a word in the worksheet but i have a small issue, when i find the word the cursor moves to the word but the small window where i type the text disappears , i want to run the program continuously until i press the cancel button and below is my code...

Hi All, I am having a problem with getting a specific Macro to run when the text in a cell is changed to a corresponding value. What I would like is for a Macro to be ran on one worksheet (Report) when the value of a cell (A1) on another worksheet (CaseSelect) is changed. The value of the...

Hi I’m new to VBA, so new in fact that this is my first attempt so please bear with me. I’ve applied the code below to automatically hide inapplicable rows, depending on the value in cell K6. (That value being one of the four possible outcomes of two Combo-box cell-link results -...

Hello, as the title states I want to run a macro through all worksheets in a workbook. Here is my code: Sub test1() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets Columns("M:M").ColumnWidth = 11.5 Next ws End Sub But it does only apply to the active worksheet. Can anyone see...

Hi, I am just wondering if there is an easy way to run a macro based on the values within a listbox. E.g. I have four macros for four reports. I add the names of these reports into a listbox and select them as necessary. How do I then reference them in Application.run or Call? Item names /...

Hi guys, I need help which a vba code to make excel automatically run a macro when I change a value in any cell of a specific column. I have come up a modification of the following code which is not working: 19 = target column testing spreadsheet = spreadsheet in question Refreshfilter = macro...

Hi there I am using Excel 2007. I have created a macro which is creating power point slides and populating them with data from excel cells. the new presentation is using a template (which is actually a power point with an empty slide). This means my excel macro is opening the template...