Cannot make macro relative

[light]

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

 

[Tom Ogilvy]

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?

 

[light]

Yes all blocks are seperated by one blank row. You can tell where a ne
block starts because it will be text(heading) and the end of
previous block contains numeric data.There are no row spaces in th
data

 

[light]

Just bumping this back up.In a couple of hours it went to page 3.Alot o
action here

 

[light]

huh

 

[Tom Ogilvy]

Huh??

 

[light]

I need an answer

 

[light]

David

My problem doesn't have to do with the button that makes
macro relative next to the stop button. My problem is when I record i
relative mode it doesn't come out that way. It comes out in absolut
mode.See my original post for the specifics of my problem.

Gord

If I didn't bump it up it would have been long gone into th
archives,unanswered

 

[Gord Dibben]

light

Nothing wrong with the bumping up or re-posting, just retain the original
question and text with the re-post so's we know what you are referring to.

Your original posting does not make sense to me, but that is not uncommon. I
repeat it here below.

****************************************

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.

***************************************

Do you want to append the new data below the old?

What does the Conditional Formatting have to do with the copying?

What does "formatting a space" mean to you?

"It keeps acting absolute" means?

Gord Dibben Excel MVP