hi, everyone
i am using below code to edit every cell in range.("C10:C300"),
but
now its checking every cell and edit him,
but
i want it edit only unique data,
for example -
cell 10 have data = haroon, then edit it
cell 11 have data = alan, then edit it
cell 12 have data = haroon, the skip it
Code
Sub Haroon2015_RangeEditing()
If WorksheetFunction.CountA(Range("C10:C300")) = 0 Then Exit Sub
Range("C10:C300").SpecialCells(xlCellTypeConstants).Select
Dim rngCell As Range
Dim varAns
For Each rngCell In Selection
varAns = InputBox(prompt:="Edit cell if wanted", Title:="Edit cell ", Default:=rngCell.Value)
If Not varAns = "" Then rngCell.Value = varAns
Next rngCell
Range("C10").Select
End Sub
Display More
thanx in advance