Microsoft Office Forums - View Single Post - Clear rows with vba

Thread: Clear rows with vba

View Single Post

Old

01-29-2020, 07:32 PM

BobBridges BobBridges is offline

BobBridges is offline

BobBridges uses Windows 7 64bit

Windows 7 64bit BobBridges uses Office 2010 32bit

BobBridges uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2013

Location: USA

Posts: 700

BobBridges has a spectacular aura about

BobBridges has a spectacular aura about

Default

That's easy, DIMI:

Code:

' ows is your worksheet object
' vr is the row you're examining
If ows.Cells(vr, 1).Value = 0 then ows.Rows(vr).ClearContents

Reply With Quote