Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i am having issues with the code below:
Dim strCellAbove As String Dim strCurrentCell As String Dim s As String Dim cell As Range nlastrow = ActiveSheet.UsedRange.Rows.Count + ActiveSheet.UsedRange.Row - 1 myrow = Selection.Row howmany = nlastrow - myrow Set cell2 = Range(Selection, Selection.Offset(howmany, 0)) cell2.Select For Each cell In Selection If cell.Value = LCase(cell.Value) Then cell.Offset(-1, 0).Value = cell.Offset(-1, 0).Value & " " & cell.Value ActiveSheet.Rows(cell.Row).Delete End If Next Example: JACK AND JILL Jack and Jill jack and Jill i need the code to read the first word and determine if it starts with a capital letter or not. currently it looks for all lowercase so looking at the third example it sees this as uppercase because "Jill" is capitalized. i need it to focus only on the first word of the text string. Anyone with any ideas? God bless jsd219 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Capitalized Excel Data | Excel Discussion (Misc queries) | |||
Count # of Capitalized Characters | Excel Discussion (Misc queries) | |||
CAPITALIZED ALL WORDS FROM WROKSHEET | Excel Discussion (Misc queries) | |||
convert capitalized text to small text (with Capitalized names an | Excel Discussion (Misc queries) | |||
determine page number in Word document | Excel Programming |