Anyone have a macro that will work for large rowsets?

I found one at http://www.ozgrid.com/VBA/ExcelRanges.htm....which works fine
if I have less than 20k rows. If I have more than that it inserts a lot of
blanks rows, but at the top, instead of at each row change...

But my worksheets routinely have 40k rows. Obviously if I have say 50k rows
and try to add 20k blank rows, well that's more than the 64k that Excel can
handle....in such case I should get a warning popup. Anyone have a way to
check a cloumn for changes and InsertRows en masse (looping through each rows
is so slow...)?

I have a sample file I can foward to anyone that needs it.

Post back and provide some information about what you have. You say "row
change". What is that? You say "check a column for changes". What do
mean? Explain it as though you were talking to someone who doesn't know
your business. HTH Otto
"LydaRA45" wrote in message
...
Anyone have a macro that will work for large rowsets?

I found one at http://www.ozgrid.com/VBA/ExcelRanges.htm....which works
fine
if I have less than 20k rows. If I have more than that it inserts a lot
of
blanks rows, but at the top, instead of at each row change...

But my worksheets routinely have 40k rows. Obviously if I have say 50k
rows
and try to add 20k blank rows, well that's more than the 64k that Excel
can
handle....in such case I should get a warning popup. Anyone have a way to
check a cloumn for changes and InsertRows en masse (looping through each
rows
is so slow...)?

I have a sample file I can foward to anyone that needs it.