Search results

Hi , The real problem is this line : Range("A2:R50").Copy The origin for the copy is A2. When you copy to a new workbook and a new worksheet , since nothing is specified , the origin for the PasteSpecial is A1. Which is why P7 in your original worksheet is now in P6 in the newly added...

Hi , This works : Sub Belle() Path = "F:\Excel File Downloads\" ' Change this to suit File_name = Path & ThisWorkbook.ActiveSheet.Range("P7") & ".xlsm" Range("A2:R50").Copy Workbooks.Add With ActiveSheet .PasteSpecial...

Hi , Have you tried displaying the filename ? What does it show ? Does the folder exist ? Have you tried changing the file format to 51 and seeing whether that works ? If you can upload your workbook , it will help. Narayan

Hi , Instead of using the enumeration code of 52 , have you tried using the actual VBA code of xlOpenXMLWorkbookMacroEnabled ? So your line of code would be : ActiveWorkbook.SaveAs Filename:=Path & Filename & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled Narayan

Hi , Would it be more convenient to have separate tabs for each stand ID ? Then it is just a case of copying the template worksheet as many times as there are unique stand IDs. Each tab is named after its stand ID , and thereafter the Stand ID column can be filled in with this ID. Narayan

Hi , See the attached file. Narayan

Hi , If you can upload your workbook with all of the code in it , it will be quicker , otherwise , we will be going through a lot of trial and error to resolve the issue. If the code which opens the browser window for a login returns control to Excel once the process has completed , then why...

Hi , Creating the buttons is just a matter of using the Excel menus. Click on the Developer tab. Click on the Insert Controls button on the Ribbon. Click on the first control under the section labelled Form Controls , which is a Button. Click on the worksheet where you wish to place this...

Hi , How did you introduce the subtotals for the Price Range ? Narayan

Hi , Once this merge/join is over , what is the next action that you take on this merged data ? Narayan

Hi , Google gives the following results : 1. https://www.freshminds.co.uk/minds/consulting-skills-hub/post/2015/02/02/top-6-websites-for-learning-vba-for-macros 2. https://blog.cometdocs.com/the-best-places-to-learn-vba-online 3. https://analystcave.com/ 4. https://www.homeandlearn.org/...

Hi , Suppose you don't have your Workbook_SheetChange procedure , does control return back to Excel with a change of the active worksheet ? Narayan

Hi , Then why not just use a Delay of as much time as it takes for the login process to complete ? Narayan

Hi , I do not understand why you need to check whether Excel has the focus. The code that is bringing up the browser and the relevant website page is from Excel , and once the page has loaded , control will be returned to Excel. Following your line of code : IE.Navigate you need to have the...

Hi , Please upload your workbook with adequate data in it. Narayan

Hi , Sorry , but the formula is an array formula , and should be entered using CTRL SHIFT ENTER. Narayan

Hi , See your file now. 3 named ranges have been defined : StartDate , referring to the cell A2 EndDate , referring to the cell B2 Holidays , referring to the range $D$2:$D$15 Narayan

Hi , See the attached file. Narayan

Hi , There seem to be a few things wrong here : What exactly do you want the following code to do ? Private Sub Worksheet_Calculate() If Range("C4").value = 1 Then MultiPage1.Pages(0).CheckBox1.value = xlOn Else MultiPage1.Pages(0).CheckBox1.value = xlOff...

Hi , The issue is not the capitalization dates ; it is that if you have multiple investments in one row , as you have in C7 , isolating the investment dates , and then applying the Life in B7 to each individually is beyond me. If there is only one investment date in C7 , then it becomes...

Hi , Does that mean your problem is resolved ? Narayan

Hi , You mention : What is this calculation ? Then again you mention : What should be done in this case ? It would help if instead of using an Excel formula , you can explain the outcomes in all possible cases , in plain English. Narayan

Hi , I don't have the time or the inclination or the Excel mastery to cater to multiple investments in one row. I think you should change the way the data is input so that every row has only one investment which is capitalized. Narayan

Hi , Upload your workbook if possible. Narayan

Hi , Use the LARGE function to return the largest , second largest , third largest ,... values in a range. =LARGE(P2: P411 , 1) is equivalent to =MAX(P2: P411) =LARGE(P2: P411 , 2) will return the second highest value in the range. =LARGE(P2: P411 , 3) will return the third highest value in...