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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top