I need to run a macro that looks at a cell to figure out how many rows down to copy. In other words, if the cell (a1) has "19" in it, then the selection b1:c<b>19</b> would be selected. I have the rest of the code figured out, thanks for your time!