finding a row with border in VBA

  • Thread starter Thread starter dana_livni2000
  • Start date Start date
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
 
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/
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic border formatting based on dates. Use VBA? 1
VBA set thick borders around non empty cells in range 0
Excel VBA 1
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Excel Borders not printing in Excel 8
Inserting a Copied Row inside a table 6
Row heights change when printing bug? 1
loop until empty row and column problem (format cells until the lastrow and column in a report) 2

Back
Top