Loss1003
02-08-2012, 01:01 PM
I have two named ranges on a work sheet (NewYear) and (ActName). I'm having problems editing the following code to only delete the blank rows inbetween the named ranges without deleting the named ranges.
Rows("1:" & Range("NewYear").Row - 1).Delete
the above code deletes all the rows above the New Year named range.
Rows("1:" & Range("NewYear").Row - 1).Delete
the above code deletes all the rows above the New Year named range.