Hello!

I'm modifying an existing macro. Within the macro, there is a formula that
needs to be copied until the information from the previous column ends. Since
the column the formula is actually in starts out blank, how do I tell Excel
to stop when the information does? Right now, I've tried shift down but it
copies zeros down the rest of the column. Can anyone help?