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...
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...
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"
My current test spreadsheet has four rows (all of which should be deleted by this), but it only deletes two of them. I...