Delete cell content based on adjacent cell value

[Anarki]

Hi Guys

I am trying to create some code for a mcaro but lack the knowledge to put it all together

I have column B filled with a name in each cell
I have column C filled with a number adjacent to each name in column B (Not all names have data in the adjacent cell)

I need to delete the data from each cell in column B if its adjacent cell in column C is blank

Any ideas how i can put this together?

Your help is greatly appreciated

Thanks,
Mick

 

[Legacy 68403]

try the following code

Range("B1").Select
Do While Not IsEmpty(ActiveCell)
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop
ActiveCell.EntireRow.Select
Selection.Delete Shift:=xlUp
ActiveCell.Offset(0, 1).Select
Loop

 

[Boller]

[C:C].SpecialCells(xlCellTypeBlanks).Offset(0, -1).ClearContents

 

[Anarki]

Boller your code works great! thanks so much for the quick response

Damnnnn i was not able to get your code to work properly but thanks for help