Alphanumeric Recognition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NewToVB - 25 Jan 2008 16:08 GMT

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 to this Message

Rick Rothstein (MVP - VB) - 25 Jan 2008 16:32 GMT

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

> 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 to this Message

NewToVB - 25 Jan 2008 16:39 GMT

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

> 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
[quoted text clipped - 13 lines]
> > 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 to this Message