steveo411
10-26-2018, 02:43 PM
Hi.... I would like help with the following
I would like to create a macro that will add a top border to a row (from A:Z)if the cell in column E is not empty. The coding would only have to check down 200-250 lines.
The only other way I can explain it is to use an Excel Formula:
IF E14 <> "", add top border, then check the next row
IF E15 <> "", add top border, then check the next row
IF E16 <> "", add top border, then check the next row
IF E17 <> "", add top border, then check the next row
etc......
Thanks
I would like to create a macro that will add a top border to a row (from A:Z)if the cell in column E is not empty. The coding would only have to check down 200-250 lines.
The only other way I can explain it is to use an Excel Formula:
IF E14 <> "", add top border, then check the next row
IF E15 <> "", add top border, then check the next row
IF E16 <> "", add top border, then check the next row
IF E17 <> "", add top border, then check the next row
etc......
Thanks