re-write

  1. S

    Simple way to re-write VBA code?

    So I have some code that I have written referencing arrays, named ranges, and ranges. I have taken the workbook and re-designed it to be table based. I figure I will have to re-write the VBA code to reference the table objects instead of the ranges, right? Is there a simple way to do this or...
  2. J

    How to condense a nested MIN/MAX formula in IF statement

    Hi all, I want to somehow condense the red and blue sections below so my formula isn't so bulky. Background: this formula is returning the first or last invoice date for select products depending on drop-down selection. All works fine... But Is there a way to condense this so I don't have to...
  3. F

    Loop through table from last row to first

    Could someone help me revamp this: Dim c As Range For Each c In Range("Table1[Entity Code]") If c.Value = "R" Or c.Value = "T" Then c.EntireRow.Delete End If Next My current test spreadsheet has four rows (all of which should be deleted by this), but it only deletes two of them. I...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top