can i define the macro to take anyhting between a-z

[sunilvedula]

i want the macro to copy from excel anthing that contains between A to Z and if the copied cell in excel does not contain between A -Z it should stop. How do i do that?

[jason]

I'd try something like this:

If Variable %T1% = "A"
 OR
If Variable %T1% = "B"
 OR
If Variable %T1% = "C"
 // Enter remaining IF and OR statements
 Clipboard Copy
 // Enter code to process clipboard information
Else
 Macro Stop
End If

[sunilvedula]

i understand that but is there no other way of telling it to take from a-z like IF clipboard contains "a"- "z". Can we do anything like that rather than giving all the variables for all the alphabets

[paul]

What about this?

Variable Set String %T1% from Clipboard
If Variable %T1% >= "A" --Ignore case is ticked
 AND
If Variable %T1% <= "Z" --Ignore case is ticked
 Do something
Else
 Don't do something
End If

[sunilvedula]

it is resolved thanks a lot. It has been resolved with the post IF variable..