Good Morning Folks,
In my worksheet(SHIFT) I have a range of cells(A4-A35) that are imported. Occasionally there are cells that are BLANK. I need to run a formula in a macro that tests A4-A35 for BLANKS. Example if A4 were BLANK, It copies N4 and paste special, value in A4 and so forth to A35.
Any help would be appreciated.
Thanks,
B
In my worksheet(SHIFT) I have a range of cells(A4-A35) that are imported. Occasionally there are cells that are BLANK. I need to run a formula in a macro that tests A4-A35 for BLANKS. Example if A4 were BLANK, It copies N4 and paste special, value in A4 and so forth to A35.
Any help would be appreciated.
Thanks,
B