Author Topic: how to get extract only bold value from excell sheet  (Read 507 times)

Offline Pradeep

  • Jr. Member
  • **
  • Posts: 5
  • Karma: +0/-0
    • View Profile
how to get extract only bold value from excell sheet
« on: March 02, 2011, 10:42:59 AM »
hi  ,


how to get extract only bold value from excell sheet

Thanking you
Pradeep.
« Last Edit: March 02, 2011, 11:12:02 AM by Pradeep »

Offline Mayasen

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 189
  • Karma: +0/-0
  • Mayasen
    • View Profile
Re: how to get extract only bold value from excell sheet
« Reply #1 on: March 03, 2011, 02:49:17 AM »
Use the search option in the following way to find the "Bold" values.

1. Ctrl+F
2. Leave the keyword (search) item empty
3. Expand the options field
4. Click the "Format" option; from the list, select "Format"
5. In the opened pop-up, go to "Font" page
6. Select "Font style" option as "Bold" and click "Ok"
7. Now click "Find" (Search) button in the search window
8. Expand the search window by click and drag the bottom right corner
9. Now you can find the location and the content which are in bold in the selected sheet.

Wishes..!
 
--
Mayasen

advertisement

Offline Pradeep

  • Jr. Member
  • **
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Hi maysen,

sorry for wrong question , my question is how to extract the bold value from excell sheet by using vb script.



Thanking you
Pradeep