I use a named dynamic named range in my workbook for a daily report. After I copy into a spreadsheet a bunch of data, I manipulate some of the data. Some of the rows get deleted that I don't need. The odd thing is after I delete all of the unnecessary rows and create the named dynamic range, one blank row keeps appearing in the range. I then try to delete the blank row but when I view the range in the edit mode, I still see that the blank row is included.
Here is the formula that I am using:
=OFFSET('Daily Summary'!$A$2,0,0,COUNTA('Daily Summary'!$A:$A),COUNTA('Daily Summary'!$1:$1))
Can I add another layer of code to ignore a blank row?
Thanks.