Excel VBA Macro
Help I am writing a Macro in excel an have a problem.
I need to check a Section of Cells for Values (O4:R4).
If there is a Value continue.
If NO Value then Delete Cells (A4:W4).
I cannot delete the Whole Row because there is data in other cells
(AA4:AW4).
Cells X4, Y4 and Z4 are are open and unused.
once complete I will use this to check other cells in this Row as well
as other Rows.
(A4:W4)
(AA4:AW4)
(BA4:BW4)
(CA4:CW4)
(DA4:DW4)
Any help would be appreciated
|