finding a row with border in VBA

D

dana_livni2000

i need to do 3things using excel VBA
1. finding the first row in a worksheet which have a border.

2. find the first cell which have contant.

3. is there a way to copy only partial cell contant?

thank in advanced
dana
 
M

Mr.Cools

You can do all these 3 things with the "FIND" function provided you are
running Excel 2003

1.Press Ctrl+F
Click format and then specify the border type you want or select if
from a cell and click "FIND ALL"
2.Pressing Ctrl+Left right arrow key would take you to the first cell
with content.
The same combination would be tried with up,down and right arrow keys
3.Double click the cell you want and select the characters you want to
copy.Right click and select copy.Select your destination cell and
paste.
If you need more information,you can post it to this news group.
Take time to visit my website which has nothing to do with excel
http://allforall.bravehost.com/
 
Top