• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 171
  • Last Modified:

Getting data from Excel

Hi,

From Visual Basic I need to open an Excel worksheet and retrieve all rows which either have a blue background or blue text. Now, I can open the worksheet but is there anyway to retirve the relevant rows rather than just looping through them all?

Thanks in advance,
Dan
0
zomby_dog
Asked:
zomby_dog
  • 2
1 Solution
 
ampapaCommented:
No, I believe you will have to loop through each row to retrieve the desired information. this should work but hasn't beentested.

For i = 1 to activesheet.usedrange.rows.count
    if ActiveSheet.Rows(i).Font.ColorIndex = 5 or ActiveSheet.Rows(i).Interior.ColorIndex = 5 then
    ....
    "do something"
    end if
next i
0
 
_agj_Commented:
just a suggestion....not possible at the moment to verify it..

use the .Find function to search in the entire sheet.

the find function can be used to say, search in Formulas of a sheet. I think u shud be able to search in the Fonts/COlors.

use the range returned by find() to get the rows.

more when i check this up.
0
 
_agj_Commented:
can u send me the code snippet u used finally?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now