Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
No question here, just a procedure for the archive and (apparently) a
victual for Senior Oh's ego feed. :) Sub FindLetters() 'Evaluate all cells in selection that to find cells that 'contain standard English language alphabet letters Dim cell As Range For Each cell In Selection If UCase(cell.Value) Like "*" & "[ABCDEFGHIJKLMNOPQRSTUVWXYZ]" & "*" Then MsgBox "Cell " & cell.Address & " contains a letter!" End If Next cell End Sub Find letters in a cell Find any letters in a selection evaluate for presence of letters |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting - letters present | Excel Worksheet Functions | |||
If any specific #s are present in range, show each in another cell | Excel Worksheet Functions | |||
Sum A Range only if no text is present in the range | Excel Worksheet Functions | |||
conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
Out of Present Range Error using Excel | Excel Programming |