Hi-
matchcol = Cells(x, "cb").End(xlToLeft).Column
This code finds the next empty cell to the left of column "CB". But if theres a formula (even though the cell is blank)the code chooses that cell. How can I rearange that code so that it wont reconize a formula in the cell, but just the first cell with actuall text?
matchcol = Cells(x, "cb").End(xlToLeft).Column
This code finds the next empty cell to the left of column "CB". But if theres a formula (even though the cell is blank)the code chooses that cell. How can I rearange that code so that it wont reconize a formula in the cell, but just the first cell with actuall text?