Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Sienna Hughes   on Mar 06 In MS Office Category.

  
Question Answered By: Hubba Akhtar   on Mar 06

Sub NoNumbers()
Dim i As Integer
Dim j As Integer
Dim iLastRow As ing
Dim iLastCol As Integer

'find last row, last column number  -- left as an exercise

For i = 1 To iLastRow
For j = 1 To iLastCol
If WorksheetFunction.IsText(Cells(i, j).Value) = True Then _
Cells(i, j).Value = vbNullString
Next j
Next i

End Sub

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Delete everything in a workbook that is a number Or get search suggestion and latest updates.


Tagged: