alienscript
05-21-2010, 11:44 PM
Hi,
The code below only select the first found cell that contain any combination of "a", like "add","dad",etc.
If I want to find in row 11 after A11, of only the first found cell that contains only an upper case "A". How should I do this?
I'm using XL 2003. Thanks a lot.
Rows("11:11").Cells.Find(What:="A", After:=[A11]).Select
The code below only select the first found cell that contain any combination of "a", like "add","dad",etc.
If I want to find in row 11 after A11, of only the first found cell that contains only an upper case "A". How should I do this?
I'm using XL 2003. Thanks a lot.
Rows("11:11").Cells.Find(What:="A", After:=[A11]).Select