run

Hi guys- I am running this code on a document with ~ 25,000 rows by66 columns wide. This code right now is taking around 45 seconds to 55 seconds to run, and sometimes I get the (not responding) and it takes over a minute. I was wondering what steps in my code could be adjusted to run faster...

I have code that I successfully run for one of my forms "On Open". I am trying to modify this for another form where the code is run when I click a button on the form Private Sub Form_Open(Cancel As Integer) On Error GoTo Error_Handler If Nz(DLookup("UserName", "tbl_Users", _...

I'm trying to teach myself to use Excel solver to take the work out of manually calculating minor production details. but am struggling. Say I have a make to order job with 7 sizes and I want to run them on 5 machines. I would like the solver to find the optimal order to run them given 5...

Hi everyone, Is there a way that I can do a spell check in a UserForm, before the information is sent to the worksheet. I know I can add code to do a spell check after the information is added to the worksheet, but in my case, some of the text will be sent to two different worksheets. Therefore...

Hi Everyone, I need two macros and not sure the best way to do them I need one macro that when run take the activesheets name and adds it to Control range A35 Then another that when run looks at Control A35 and if its not empty message box's "Stop, There has been an Error, (new line) You still...

Hello, I work for an online school and supervise 31 teachers. Twice a month, I run a report which gives me the number of hours each teacher has spent online. I output the report in an excel workbook. The output has 31 tabs for each teacher's information. The tabs are Sheet 1, Sheet 2, etc. I...

Kind of an If statement. I have an If statement that depending on the results will run one or another Macro. But I get a Debug error when I try to run it. The fist is the If statement that errors the second is one of the Macro's (which runs fine on its own - its in a module) Private Sub...

hi'' I hv two workbooks open, one has macro code but anothr simple xlsx workbook I want to run the macro in anther workbook which has no macro how can I achieve this task Thanks

Hi folks, can anyone tell me why this works every alternate time it's run? Run it and it works fine. Run it again "Paste method of Worksheet class failed" Run it again it works fine. Run it again "Paste method of Worksheet class failed" etc..... Thanks. Sub CopyRows() Dim RowNum As Integer Dim...

Hi, Please can someone help me? I would like to run my code via a double click on the activesheet in my workbook. I know I can put the code in the sheets individually to run but because I have 20 plus sheets I was wondering if there was a way of having just 1 code in a workbook event instead...

Looking for a way to run this in excel. x*1.05*1.1+10 = 500 Any suggestion for this?

Now I get a message that saysCannot run the macro "XXX". The macro may not be available in this workbook or all macros may be disabled." I know the macro works because I can run it out of VBA <macros> and it ran it all worked of the Ribbon a few hours ago. So that leaves "Macros Disabled" as...

I have it to where users enter a number in cell A3. I need a macro to run after they hit enter when on cell A3 and only cell A3. They may not enter any data in cell A3, but need it to run a macro regardless if hitting enter while in cell A3. Not sure how to do that.

I am attempting in the code below so when I run the macro it will zoom to 50 and minimize then when I run the macro again it will zoom to 90 and maximize. Please help me get the code correct. Thanks as always Sub ribb_zoom() CommandBars.ExecuteMso "MinimizeRibbon" ActiveWindow.zoom =...

Hi, Please can someone help me? I have the following code which is triggering Run Time error 28 - Out of stack space. This is the only code in my workbook as well. How can I clear this error? Private Sub Worksheet_Change(ByVal Target As Range) If Range("B2").Value <> "" Then...

Hello, I have what is probably a simple question - I have this code I grabbed from elsewhere, I want it to only run in column A on all sheets (rather than on all columns as it does now): Sub DeleteRows() Dim WS As Worksheet On Error Resume Next For Each WS In Sheets With WS.UsedRange...

Hello all. I have a macro that hides and unhides several rows on a sheet, and works perfectly when on I use a button ON THAT SHEET. I have another sheet that has a checkbox that when selected, should run the exact same macro and for some reason it only runs half of it. I'm losing my mind, can...

I have a macro button that opens up an excel template file, calculates it, saves it to a new location, copies all of the cells & pastes values, and then saves the file again. This is done for about 15 files. My issue is that sometimes when I run the macro button I will find one or two or three...

Hello, Good day Mr. Excel users! Sheets("OB Raw").Activate Above code works fine. Sheets("OB Raw").Activate Sheets("forBacklog").Activate When I add Sheets("forBacklog").Activate, it doesn't work. But if I run below code, it works just fine. Sheets("OB Raw").Activate...

Good day all I'm trying to add a clause to a formula. What I want is to check cell L2 and only if it finds the word "open" then run the following formula. Any help is greatly appreciated. TIA =IF(ISNUMBER(SEARCH("Not used",E2)),"",IF(TODAY()=E2,"Today",IF(TODAY()>E2,"Past...