copy a formula down a column of varying size

[njbeancounter]

I have one worksheet that pulls information from an outside source, which includes vendor numbers and invoice dates. Once the sheet is refreshed, the vendor info populates column A. In column B, I need to remove the leading zeroes from the information in column A, which I can do. BUT, because the vendor information varies from day to day, while column A will have information, there will be empty cells in column B whenever different vendors are added. I need to copy the formula in B2 down to the end of column B, but only as far as the information in column A goes because this range is then used in a pivot table someplace else.

I have looked through the archives, but I can't find exactly what I need. Any help will be appreciated.

 

[Boller]

[B2].Copy Range([B2], [A65536].End(xlUp)(1, 2))

 

[njbeancounter]

Thanks...worked like a charm!!