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

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

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

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