Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the first few characters in a cell
Can anybody help?
What I would like to do is run a macro that will hide certain rows within a workbook, the position of the rows is variable, however all of the row I would like to keep all have the same first 5 Character, (SubTL) I can make it run through the data and remove lines. The problem is I can't make it identify which rows contain (SubTL) as the first 5 Character. Any Ideas? Thank for you help. Ben |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the first few characters in a cell
Ben,
Assumed the column is A Sub Macro10() For i = 25 To 2 Step -1 If Not Evaluate("EXACT(""SubTL"",LEFT(A" & i & ",5))") Then Range("A" & i).Delete shift:=xlUp End If Next i End Sub HTH Cecil "Ben E" wrote in message ... Can anybody help? What I would like to do is run a macro that will hide certain rows within a workbook, the position of the rows is variable, however all of the row I would like to keep all have the same first 5 Character, (SubTL) I can make it run through the data and remove lines. The problem is I can't make it identify which rows contain (SubTL) as the first 5 Character. Any Ideas? Thank for you help. Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regional Settings / Finding out Array separator characters | New Users to Excel | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
Finding Characters Conditionally - Easy Question | Excel Worksheet Functions | |||
finding occurance of characters | Excel Discussion (Misc queries) | |||
Finding cells with a specific number of characters | Excel Discussion (Misc queries) |