VBA code for deleting

Question

I'm trying to write inside a button in a userform to clear the cell if it is less than 1%

Range("G9:G28").Select Selection.ClearContents if range("g9:g28) < 0

This is probably very wrong

GSerg · Accepted Answer · 2017-02-21 18:13:01Z

2

dim c as range for each c in activesheet.range("G9:G28") if c.value < 0 then c.clearcontents next

answered Feb 21, 2017 at 18:13

78.8k18 gold badges173 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Maybe if c.value2 < 0.01 then c.clearcontents ...? I'm not sure if the narrative or the code in the OP is correct.