Thread: Excel VBA Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VexedFist[_2_] VexedFist[_2_] is offline
external usenet poster
 
Posts: 18
Default 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