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
Bookmarks