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!

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" <(E-Mail Removed)> wrote in message
news:17A133B3-4A77-4064-BFD8-(E-Mail Removed)...
> 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!

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" <(E-Mail Removed)> wrote in message
> news:17A133B3-4A77-4064-BFD8-(E-Mail Removed)...
> > 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!
>
>