links to cells prevent macro from removing blanks

[allen196661]

Hello all,

I am trying to remove blank cells from the product of a macro that copies multiple columns into column A. The problem is that the cells in the column ranges that I am copying are linked to another sheet. The macro does not recognize the cells as blank since there is a formula present. I do not want to remove the formula in the ranges as this represents data in my original sheet and future range of input that may be added. I appreciate any help.