Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphanumeric Recognition
I'm using Visual Studio/Visual Basic which is very similiar to VBA. I need
for my program to recognize when a cell has 8 alphanumeric characters in column A, and if it doesn't have 8 alphanumeric characters to delete the entire row. Any ideas on how to do this? Thanks in advance! :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphanumeric Recognition
You haven't told us much or given us code where we create a solution for you
using your own variable names; so I'll make the assumption that you already know how to delete a row and are just not sure how to insure your cell's content is exactly 8 alphanumeric characters. If Not Text Like Replace(String(8, "Z"), "Z", "[a-zA-Z0-9]") Then ' Text is **not** made up of 8 alphanumeric characters... ' so put your delete row line here End If Rick "NewToVB" wrote in message ... I'm using Visual Studio/Visual Basic which is very similiar to VBA. I need for my program to recognize when a cell has 8 alphanumeric characters in column A, and if it doesn't have 8 alphanumeric characters to delete the entire row. Any ideas on how to do this? Thanks in advance! :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphanumeric Recognition
Yes I already know how to delete rows and all, just wasn't sure about the
alphanumeric part, sorry about that. I'll try this thank you! :) "Rick Rothstein (MVP - VB)" wrote: You haven't told us much or given us code where we create a solution for you using your own variable names; so I'll make the assumption that you already know how to delete a row and are just not sure how to insure your cell's content is exactly 8 alphanumeric characters. If Not Text Like Replace(String(8, "Z"), "Z", "[a-zA-Z0-9]") Then ' Text is **not** made up of 8 alphanumeric characters... ' so put your delete row line here End If Rick "NewToVB" wrote in message ... I'm using Visual Studio/Visual Basic which is very similiar to VBA. I need for my program to recognize when a cell has 8 alphanumeric characters in column A, and if it doesn't have 8 alphanumeric characters to delete the entire row. Any ideas on how to do this? Thanks in advance! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Recognition | Excel Discussion (Misc queries) | |||
Cell recognition | Excel Worksheet Functions | |||
Barcode recognition | Excel Discussion (Misc queries) | |||
Text recognition | Excel Discussion (Misc queries) | |||
speech recognition | Excel Discussion (Misc queries) |