Thursday, 22 August 2013

vba macro - clear specific cell value only

vba macro - clear specific cell value only

I need to clear cells value "noinfo" in a wide range (more 1000 rows). I
use the macro mentioned below, but it's very slow. Maybe there is better
way to perform this task?
For Each cell In Range("L2:N" & Range("N" & Rows.count).End(xlUp).Row) If
cell.Value = "noinfo" Then cell.ClearContents Next cell

No comments:

Post a Comment