run

Hello, Is there a VBA code that can select a workbook and run different macros on condition? For example: If sheet 1, cell: A15 says the word "Blue" Go to Sheet 3 run macro for blue Or If sheet 1, cell 15 says the word "Red" Go to Sheet 2 run macro for red Or if Sheet 1, cell A15 says...

Hi, Since yesterday, I've noticed a number of macros running slower than before. I was using Excel 2013 and about a month ago upgraded to Office.365 I have a range A1:AK39 where A1 = Table name A2:A39 Months of the year, starting Mar 2019, ending Mar 2022 A2:AK2 Months of the year, starting...

I am comparing year-to-date financial statements with Budget and prior year. I want to return the sum of the row that starts with January and increases by 1 each month. I was thinking it was an INDEX function that could start the sum in the first column and then run over the specified number...

I have a complex formula that was previously working for the last 6 months. Now when I try to run it, it just gives me a #VALUE ! error. The data set over the last 6 months and now is basically the same volume. I haven't change the formula, the layout of the columns, tab names, nothing ...

I'm running a macro that closes the current workbook. The macro is run by an icon on the QAT and the code is in the MyWB.xlsm project. When the last VBA command is executed (ActiveWorkbook.Close SaveChanges:=True)), I get the 'Automation Error. Exception Occured'. When MyWB.xlsm is active and I...

Hi all, I want to make the spread sheet automatically run this macro code when a number is inputted into column B what code do i need to add to it Sub Ratio_BC() Dim Lastrow As Long Application.ScreenUpdating = False Lastrow = Range("B" & Rows.Count).End(xlUp).Row Range("D2:D" &...

Hello All, What I'm trying to do, is run some Outlook VBA code to set up the Outlook environment, before asking the Excel VBA code to work with Outlook. This is a 2-step solution, and I was wondering if I can make it a 1-step solution by running the Outlook VBA code at the beginning of the...

I have a Front_DB_A with a table called RS and another Front_DB_B with a table called RS_Hist, both are split databases and have tables linked to the Front_DB_A database. My dilemma until we can move it to SQL Server which we are waiting on is that I have a run a query that will combine both...

Sub TestVoices() Dim i As Long Dim voc As SpeechLib.SpVoice Set voc = New SpVoice i = [RANDBETWEEN(0,2)] Set voc.Voice = voc.GetVoices.Item(i) voc.Speak "I want to run next lines while voice is playing" MsgBox i End Sub In other versions I could do that , like this: Application...

Hi there need some urgent help please to finalise a spreadsheet. I have a load of data entry boxes and then a button assigned to a macro to do some goal seek type calculations over several tabs and it calculates a resulting figure in the same front sheet in say cell F10. What i want to do is...

Hi, I'm pretty new to VBA, and was hoping someone might be able to help me with something i am trying to write: Sheet 1 (input tab): Row 1 contains Mon-Fri, with the rows below detailing what car parking spaces are available for those days, for example, if space 18 is available on monday...

Hello, So i have a sheet when someone clicks a button and it shows the relevant hidden cells. However i would like to restrict this to only approved people to have access to run this code. Is it possible to have a list of users in 'Settings' sheet, and once the code is activated to run it or...

Hello guys, I am currently processing a huge dataset. My question is that how can I ignore NA when I want to run and repeat this function in excel. =IF(AND(RankLN!D45>0.3,RankLN!D45<=0.7),"M",IF(RankLN!D45>0.7,"W","L")) In detail, for example, I have a column, we say column D. In this column...

I have a macro running that seems to have run away and will not stop without control alt delete. Also ESC or CTRL-BREAK also don't work. IT's so weird. Sometime I will allow it to run over night and the next day it will be done and other times it will still be running. There is no rhyme or...

I have a macro that will be run several times throughout a worksheet. First time I run macro it will fill column AF down to a certain # of rows based information in column A. Lets say in this case row 20. Then if we need to add more rows below this, I want to re-run the macro so it will...

Hi, I'm looking to have an excel file in my windows startup group and have it run when windows loads. But I would like to have the code ONLY run once a day. So if the code has already run today don't run it again till it's loaded tomorrow. I can add a Power Pivot calculated column and have it...

Hello all, My code is working as intended. There is a long waiting period as a consequence of the code run that I would like to call a 3D animated model I have to just run onscreen while the code is running in the background. I cannot figure out how to call it from VBA to appear as this...

Hi I have a spreadsheet which has over 1000 lines, all for varying companies. What I would like to do is create an option so when you run it, it will copy the relevant lines to their respective sheet. The code listed below is some I have seen on here, which works to a point. It will run for one...

I have the following Macro that saves a file to a different location with the file name being what is in cell B7. Sub FileSave () Dim FP As String, FN As String FP = "Ë:\Quotes\" FN = Range("B7").Value ActiveWorkbook.SaveAs filename:= FP & FN & ".xls" End Sub How do I get this to RUN...

I have a new desktop computer and since I started using it any Excel file with a macro will run the script and then just close Excel. There are no errors, nor does it matter which Excel workbook I use. These previously worked fine on a different computer, and other colleagues are able to use the...