hello
i m using below code to edit cells one by one in range, but there is little problem, if there is no data in range (c10:c300) and i run code then there is coming up a debug,
i want if there is no data in range C10:C300 then exit the sub,..
Sub Haroon2015_RangeEditing()
Sheets("ENTRY").Select
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