Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is some code i've used to copy values from cell to cell and i now want
to make all the cells with letters (a, b, c, etc) in them blank. For the life of me i can't make any that actually start with a number become blank. Help would be appreciated. Sub Codes() Sheets("Town Pubs Cross Ref report").Activate Range("B3").Select Do If ActiveCell.Value = "" Then ActiveCell.Value = ActiveCell.Offset(0, -1) End If ActiveCell.Offset(1, 0).Select Loop Until ActiveCell.Row = 21568 End Sub Sub Delete() Sheets("Town Pubs Cross Ref report").Activate Range("B3").Select Do If ActiveCell.Value < "?????" Then ActiveCell.Value = "" Cancel = True End If ActiveCell.Offset(1, 0).Select Loop Until ActiveCell.Row = 21568 End Sub So basically i want to clear any cell in column B that has a letter in it regardless whether it has a number in it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting the ' character | Excel Discussion (Misc queries) | |||
Deleting first character issue | New Users to Excel | |||
Userform: looking for and deleting character | Excel Programming | |||
Deleting the same character automatically in each cell | Excel Worksheet Functions | |||
Deleting the leading character in a series of cells | Excel Programming |