hello
i m using below code to edit data one by one using inputbox
e.g
i have data in c10:c20 and i play code then there is popup inputbox 10 time to edit every cells data one by one
or
i have data in c10:c30 then popup inputbox 20 time to edit every cells data one by one

i want click only one time the inputbox and edit cells one by one (don't popup inputbox 10 times or 20 times)

thanx

Sub Haroon2015_RangeEditing()
Sheets("ENTRY").Select
If WorksheetFunction.count(Range("C10:C300")) = 0 Then Exit Sub
Range("C10:C300").SpecialCells(xlCellTypeConstants).Select
Dim rngCell As Range
Dim varAns
'For Each rngCell In Range("C10:C25")
For Each rngCell In Selection
  varAns = InputBox(prompt:="Edit cell if wanted", Title:="Edit cell " & rngCell.Address(0, 0), Default:=rngCell.Value)
  If Not varAns = "" Then rngCell.Value = varAns
Next rngCell
End Sub