Resetting cells with 0 to empty cells
How do i reset cells wich contain 0 (zero) to an empty cell.:
1.For an entire column 2. For a certain range, example I2 to I25 Thanxxx, Luc |
Resetting cells with 0 to empty cells
ActiveSheet.Range("I2:I25").Select
Selection.Replace What:="0", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False -- Best wishes, Jim "Luc" wrote: How do i reset cells wich contain 0 (zero) to an empty cell.: 1.For an entire column 2. For a certain range, example I2 to I25 Thanxxx, Luc |
Resetting cells with 0 to empty cells
Select the cells (column or just a set of them) and run:
Sub clearum() For Each r In Selection If r.Value = 0 Then r.Clear End If Next End Sub -- Gary''s Student gsnu200709 "Luc" wrote: How do i reset cells wich contain 0 (zero) to an empty cell.: 1.For an entire column 2. For a certain range, example I2 to I25 Thanxxx, Luc |
Resetting cells with 0 to empty cells
To replace 0 with "" in Column B:
Range("B:B").Replace What:="0", Replacement:="", lookat:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False To do the same thing for I2 to I25, replace "B:B" with "I2:I25". "Luc" wrote: How do i reset cells wich contain 0 (zero) to an empty cell.: 1.For an entire column 2. For a certain range, example I2 to I25 Thanxxx, Luc |
Resetting cells with 0 to empty cells
Range("B:B") = empty
"Luc" wrote: How do i reset cells wich contain 0 (zero) to an empty cell.: 1.For an entire column 2. For a certain range, example I2 to I25 Thanxxx, Luc |
Resetting cells with 0 to empty cells
Range("B:B") = empty
"Luc" wrote: How do i reset cells wich contain 0 (zero) to an empty cell.: 1.For an entire column 2. For a certain range, example I2 to I25 Thanxxx, Luc |
All times are GMT +1. The time now is 02:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com