Hello! Hope all is well!

I created a macro that manipulates some data and it works great
however, one part of the macro takes a value and copies it down th
entire column because it doesn't change.

Unfortunately, the amount of data in the spreadsheet (rows) is dynamic
So when I run the macro on two different sets of data, I sometime
have too much copied down the column so it looks like this:

xxx xxx xxx xxx 0019 xxx xxx xxx
xxx xxx xxx xxx 0019 xxx xxx xxx
xxx xxx xxx xxx 0019 xxx xxx xxx
xxx xxx xxx xxx 0019 xxx xxx xxx
001

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