vba .formula

  1. T

    VBA deleting a worksheet based on a cell

    Hello, I am trying to create a VBA to delete a worksheet based on a cell. I know the VBA to delete an active worksheet, but in this case I am working with a template that contains 34 worksheets and based on contracts I may not need them all "every time". So I would like to create a VBA that...
  2. M

    create a vba function with two tables where table1(three columns), table2 has (1 row and 1 column)

    create a vba function with two tables where table1(three columns(with 20 rows)), table2 has (1 row and 1 column), match entries in table1 column1(with 20 rows) with table2 row1(20columns) and match table1 column 2 with table 2 column 1 and enter value in corresponding row and column found from...
  3. D

    VBA Runtime Error 1004 Unable to Get Match property of the WorksheetFunction class

    Hello, I am looking to populate a calendar grid with select piece of information. My Calendar Grid sheet is named "Calendar". The sheet with the data is named "Input". The macro successfully completes one cycle but I get an error in the 2nd cycle once I arrive at the Cindex line of code...
  4. A

    Multiple criteria Sum, Merge & Delete Rows

    Hi Everyone, I am not sure what is the best way of solving this problem whether its some advanced function, or VBA/Macro route. What I am trying to accomplish is to merge and sum multiple rows for the same invoice number. So, if for INV1 there's multiple product line with same product line...
  5. R

    VBA to get cells from workbook on network drive very slow

    I'm fairly new to VBA in excel and have been going through several beginning books to try and accomplish getting values from closed workbooks on a network drive and populating them into my main Dashboard workbook. The only problem is they are for a running 13 months, so the files will change...
  6. B

    Run excel formula through VBA

    I am trying to VLOOKUP some value in 2 sheets and if the value is found then i am putting a hyperlink on the Sheet 1 cell to point it to the Sheet 2 cell. I have written an Excel formula for the same and it is working fine. But i am unable to convert it into a VBA formula. I tried many...
  7. C

    VBA code--Organizing data

    Hello, I'm trying to find a way to get a macro to organize my data. I have the following data that was generated: Large C US Large C US Large G US Medium C US Medium G US Small V US Small C US DM C International DM V International EM G International EM C...
  8. P

    Coefficient of Dispersion: Create a UDF to average a range of cells

    I wish to create a UDF that calculates a formula used in Mass Appraisal of Real Estate I use MS Excel 2007, and Windows 7 This is a sample what my Data looks like: <tbody> AssessedValue SalePrice Ratio = AV/SP 90 88 1.02 90 93 0.97 90 87 1.03 90 94 0.96 90 85 1.06 90 96 0.94...
  9. C

    How to loop through all rows of a range?

    Hi, I have coded a macro that effectively copies a dynamic named range to a sheet called Sales chart. The working named range, called ItemsSold, is a single column consisting of uniquely filtered data. My problem is the second named range; I want it to look up the source data, called Sales...
  10. K

    fmMultiSelectExtended

    Hello, I've been searching the web for hours and it seems I just can not locate exactly what I need. I'm hoping someone can assist. I've created a userform that has a listbox which users can add items. I have set the RowSource to the named range in the Excel spreadsheet that will also hold...
  11. A

    Calender

    Hi Guys, I need to make an excel sheet, when that excel sheet will open, it will ask you for the calender, and once we select the calender it will automatically pops up the date and day on the top like this: Start of Excel: Select Calender: 3/2/2015 - 3/8/2015 In columns: <tbody> 3/2/2015...
  12. I

    create multiple x y charts, one for each column with the same x axis using excel-vba

    <tbody> Hi, I've been working on the problem of automating the plotting of line diagrams. But I did not yet manage to solve it yet. I would need multiple charts one for each column (from E to R) using the same column (B) for the X axis. The ultimate...
  13. I

    Help with using a formula to define the selected range in VBA

    Hello, I would like to do something like this: Range("=CELL(""address"",INDEX(INDIRECT(R2C12),3,2))").Select ActiveCell.FormulaR1C1 = "=CELL(""address"",INDEX(INDIRECT(R2C12),3,2))" will put the formula into the currently active cell, but I can't get the VBA to select a range based off the...
  14. MrManBoy

    VBA to create/add formulae to a range of cells

    Gday All, Trying to achieve: I have a list of formulae that I need to enter into a particular "Sheet" via VBA. The range is H2:X5000. I have searched far and wide across the internet only to find solutions that do not yeild any results, literally for some reason. Examples of some of the...
  15. Q

    Finding data from one spreadsheet and pasting it to another

    Good day, I have a userform that has a start and end date in it and then three checkBoxes (1st, 2nd and repeat) I have managed to get the first and second section working fine, however part three has me at the end. In 1st and 2nd it just has to get the info from two columns (the first time and...
  16. P

    VBA code :::::: Compile error: Expected : list separator or )

    I am trying to get the multiple results form a Range and cannot use vlookup so using INDEX Function. My formula "=INDEX(Sheet1!$A:$I,SMALL(IF(Sheet1!$A:$A=$A$2,ROW(Sheet1!$A:$A)),ROW(2:2)),7)" worked perfectly but not working in VBA code. I am getting "Compile error: Expected : list separator...
  17. F

    Replace in VBa

    Hi, in Excel I'm using formula: A2 = REPLACE(A1,1,FIND(":",A1),""). Now in VBA I did like: ws.Range("A2").Value = "REPLACE(A1,1,FIND("":"",A1),"""")" and it's ok. How can I directly assign value from formula to my variable??? I had something like below but is wrong :/ Dim new_value as...
  18. T

    Inserting an IF Formula using VBA

    Hello everyone! I am trying to insert the following formula into my current code: =IF(B2="","",B2+30) This formula is pulling the date entered into cell C2:C and responding in D2:D by adding 30 days to that date. I am not sure how to do this. Can anyone help?! What I am wanting is for the...
  19. Z

    Insetr Text and SubTotal/Autosum

    Hi, Can Someone help me with the VBA? I have code but i dont know how to change to insert Text and then Total. Sub Test() Dim Rng As Range Dim x As Long Set Rng = Range("F1:F" & Range("F65536").End(xlUp).Row) For x = Rng.Rows.Count To 2 Step -1 If...
  20. C

    VBA work-around to preserve Hyperlink when using VLOOKUP?

    Hello all, I am looking for a pure VBA solution to a small issue I am having when trying to preserve a hyperlink when using VLOOKUP. I have two worksheets within the same workbook. Worksheet 1 contains a lot of information for internal use(many of the cells in all of the columns contain...

Some videos you may like

This Week's Hot Topics

Top