How to select only cells wtih data

[mbesspiata]

I run a pivot table to extract data from a report and break it out into pending days of 30 day periods. I then select the 4 cells from 1 to over 90 days to copy and paste into another report. The problem I have is some of my reports don't have data in all the 30 day ranges and my selection of the 4 cells then brings in my total cell and a blank cell if only 2 ranges are used: see below for example. The letters are the column letters. My macro selects j4-m4 where if all the ranges were used would not include the total cell or a blank cell.
The bottom line on the example is what would be included if all ranges were filled. How can I write something to limit my selection to only the cells in the 1-30, 31-60, 61-90, and >90 IF THEY HAVE DATA IN THEM?

Mike

I</SPAN>	J</SPAN>	K</SPAN>	L</SPAN>	M</SPAN>	N</SPAN>
Count of Seizure Number</SPAN>	DYSOLD</SPAN>
STAT</SPAN>	1-30</SPAN>	31-60</SPAN>	Grand Total</SPAN>
80100</SPAN>	78</SPAN>	23</SPAN>	101</SPAN>
Grand Total</SPAN>	78</SPAN>	23</SPAN>	101</SPAN>
			61-90</SPAN>	>91</SPAN>	TOTAL</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL span=2><COL><COL span=2></COLGROUP>