Definition for sp characteres in vba

[santoshloka]

i couldnt find this meaning in google search,i want to know about this special characteristics for?

1)*#*
2)"*"
3)"@"
4)"???.???"
5)xlWhole, , , , False, True
6)"[!0-9A-Za-z]"
7)"."
8)Cells(@,1)
9)""

 

[Rick Rothstein]

Re: Defination for sp characteres in vba

i couldnt find this meaning in google search,i want to know about this special characteristics for?

1)*#*
2)"*"
3)"@"
4)"???.???"
5)xlWhole, , , , False, True
6)"[!0-9A-Za-z]"
7)"."
8)Cells(@,1)
9)""

You cannot ask that question without putting each of them into some kind of context. In and of themselves, they are just collections of characters... they can only take on special meaning when placed in use somewhere.

 

[santoshloka]

Re: Defination for sp characteres in vba

1)For X = 1 To Len(Data(R, C))
If Mid(Data(R, C), X, 1) Like "[!0-9A-Za-z]" Then Mid(Data(R, C), X) = " "
Next
2)If Data(R, C) Like "*#* *#* *#* *#*" Then
Data(R, C) = Replace(Application.Trim(Data(R, C)), " ", ".")
Else
3).NumberFormat = "@"
4).Replace "???.???", "", xlWhole, , , , False, True
5) Data(R, C) = Replace(Application.Trim(Data(R, C)), " ", ".")