How do you tell where a block starts.

are all blocks separated by at least on blank row?

do blocks not contain any completely blank rows?

--
Regards,
Tom Ogilvy

"light " wrote in message
...
Making a macro that formats "blocks" of data. The data I import has
differernt number of rows in the blocks,colums are the same. The number
of blocks per sheet will range from 8 to 14.Each block has it's own
header.

I format a space under the header of each block. I also apply
conditional formating to that block. I've tried recording in relative
and absolute.

So now when I import another sheet of data,since the blocks are
different sizes(row wise) they start on different numbered rows than
the original.The formatting won't cross over without huge errors like
creating the space between the header and the data,but in the data
itself. It keeps acting absolute.


---
Message posted from http://www.ExcelForum.com/