Hi, this is REALLY frustrating me.
I've been trying to have a macro that removes the bottom row of a sheet. I have tried literally every solution I've seen and none of them will work. They all think the bottom row is 25, or 220, (when they're all blank). The bottom row should be 4.
With that said, I've decided to try a different method. I've created a named range "RIFRange", which will select my table, not including the bottom row.
=OFFSET('RIF Events'!$A$1,0,0,COUNTA('RIF Events'!$A:$A)-1,COUNTA('RIF Events'!$1:$1))
What I'd like to do now, is clear the inverse of my named range. I've seen some people suggesting you can store the named range content in memory, clear everything and then repaste the content. I'm just having a hard time with my code recognizing the range.
Any help would be greatly appreciated!