Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

finding a row with border in VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dana_livni2000@yahoo.com - 22 Jul 2006 08:29 GMT
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
Mr.Cools - 22 Jul 2006 12:28 GMT
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/

> i need to do 3things using excel VBA
> 1. finding the first row in a worksheet which have a border.
[quoted text clipped - 5 lines]
> thank in advanced
> dana

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.