Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look for numbers in a cell
Hi all,
I spent some time in another solution for looking account number from worksheet, but no progress at all :( In the first column of worksheet, there are some cells which are mad up of names and an unique account number (6-digit-form). However, some cells are padded with spaces, i.e. 123456 ABC 123457 CDE 345678 EFG I would like to find all cells with account number out and highligh them. My code: Sub find_Acct() Dim result As Integer, c As Range For Each c In ActiveSheet.Columns(1) If IsNumeric(Left(Trim(c.Value), 6)) Then 'Highlight the cell End If Next c End Sub Any help is appreciated -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add multiple numbers in one cell with those numbers remaining visi | Excel Worksheet Functions | |||
Selecting specific numbers from a cell containing multiple numbers | Excel Worksheet Functions | |||
how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions |