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! :)

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! :)

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! :)