runs

I've created a macro that's supposed to: 1. get the account numbers from another sheet, together with their transactions 2. de-duplicate account numbers 3. calculate the number their transactions, dependent on the transaction status (pass, review, reject) 4. allocate customers to the sales...

Hello, I am trying to get my 'TidyAll' Macro to run when a cell is changed and I am using the following code Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Target.Worksheet.Range("H5")) Is Nothing Then TidyAll End Sub It is working, although for some reason...

I have written a VBA that will group items in a worksheet if certain criteria are met and collapse those groups. I have assigned a form button to run this macro so it was easier to test in different situations to make sure it would always work - and everything is going great with the actual...

Hi Everyone, Firstly just looking for ideas I can try out so if you think you can help let me know. I have a macro that runs great, its one that takes data one row at a time and finds were to put it on another sheet. I'm sure you know what I mean when I say it does the x = 1 to lastrow...

Hey I am using the below code to schedule runs of a macro. But I am worried that if there is some interruption to the scheduling, there will be a problematic delay before I pick up on it. So I'm wondering whether or not there is a way to check what and when macros have been scheduled if any...

Hi, I have the code below with the usual Application.ScreenUpdating incorporated but the screen still flashes/flickers when the code runs - everything (charts/tables etc.) momentarily disappear and re-appear when it runs so it doesn't look very slick. The page has a couple of charts reading from...

I have a control button on a worksheet that when clicked on it runs a code in VBA. For whatever reason this button is not working on my second computer. Both machines are running windows 10. There is another button on the worksheet that runs a macro and it works fine on both machines. Is there a...

Hi im running excel 2010 i have a small macro that changes the font size in coulumn "K" and runs fine After adding 4 ranges in the name manager which is a index match formula and has no referance to the cells in column "K" the macro runs at a snails pace i delete the ranges and the macro runs...

Greetings, I am not receiving a value for the variable "h" when it runs over the line below. I added "h" to the Watch box and it is reading "Out of Context" when it runs over this line. Why might this be occurring? Dim h As Integer Dim k As Integer Dim l As Integer h =...

How do I change this code, so that the macro runs when the workbook opens? Sub InsertMap_Click() 'Updateby Extendoffice 20161116 Dim Pshp As Shape Dim xRg As Range Dim xCol As Long On Error Resume Next Application.ScreenUpdating = False Set Rng = ThisWorkbook.Sheets("Executive...

So I've got this code to talk to the user while the macro runs, to prevent them from clicking all over the place and crashing the program. Sub UseSpeech() 'speech while macro runs. Application.Speech.Speak "Hello " & Application.UserName & ". Please wait about 10 seconds while the macro...

Hello All, and happy belated Thanksgiving, I have a workbook with about 20 sheets, most of which are protected. I have a Main sheet with a "Log In" command button, and based on what password you enter, you're given access to certain sheets. With that said, it all runs perfectly. And I have a...

I have the following code that changes my number formatting to number, when it started as text, but after the program runs, I still have the exclamation point and the green box in the upper left corner of the cells that says numbers formatted as text. Is there a way to get that to stop...

Hi all, I have two workbooks that are almost the same because they're from a master template workbook (I need both to be open at the same time). When I try to run a macro (Ex. Sub Calculate), it runs the Sub Calculate from the other workbook that is open. Is there a way to make sure it runs the...

So I have a list of 40,000 values in columns A and B.. Let’s say column A runs Animal1, Animal2, Animal3 and B runs Fruit1, Fruit2, Fruit3.. What I need is a bit of code that will merge these together but add a blank row in between so it then collates in column A: ANIMAL1 Blank FRUIT1 ANIMAL2...

I have a wb on my desktop which has a code embedded in it. When I double click it it runs a task then closes. How do I get into it to amend some code please?

This code runs just fine as a formula in a cell and it runs just fine in conditional formatting as long as i don't wrap an IFERROR around it. Once i wrap the IFERROR around it the comparison fails. The ADDRESS function has the correct syntax. I have verified that enter that as a formula in a...

Hello I know the error message about is a common one, however I can't trace why it is giving me this error. I have a Sub Auto_Open() in a module1 where I call a procedure under one of my sheets. This runs fine when I open the spreadsheet. In my procedure itself that gets called, I also have the...

Dim ws As Worksheet For Each ws In Sheets ws.Activate "Macro Information" Next ws End Sub I currently have this Macro that runs on all sheets on a selected workbook. I want to add a step that checks B51 on each sheet as it runs if the cell is equal...

Hi all, First off, I'm not a programmer, I just Mr Magoo my way through this stuff, copying and modifying stuff I find online. I hate to be the guy that signs up just to ask a question but after a day of searching and messing around, I'm still lost. So, thanks in advance!! I have a macro...