Blue Prism Product

last person joined: yesterday 

Chat about Blue Prism products
Expand all | Collapse all

Go to Visible cells after filtered in a columnn Excel

Jump to Best Answer
  • 1.  Go to Visible cells after filtered in a columnn Excel

    Posted 01-22-2021 10:53
    Hi ,
    need to go visible cell in a column in Excel after applying filters.

    Ex: Age column filtered >25 then i need to go first visible value after filter.

    Thanks
    KMMPost

    ------------------------------
    Murali Mohan Konanki Automation Associate
    Automation Associate
    S&P Global
    UTC
    8096961984
    ------------------------------


  • 2.  RE: Go to Visible cells after filtered in a columnn Excel
    Best Answer

    Posted 01-22-2021 11:52
    I don't think there's a way to do this with the stock VBO. I'd check this post for an example of how to do it in VBA, which could be adapted to a code stage in Blue Prism. Range("A1").CurrentRegion.SpecialCells(xlCellTypeVisible) will return a range of visible cells, then you can use the Intersect() function to determine if a specific cell or range is contained within the range of visible cells. Since this method would not require moving the active cell around, it should be pretty quick to loop through potentially thousands of cells to see if they are visible or not.

    ------------------------------
    Nicholas Zejdlik
    RPA Developer
    ------------------------------



  • 3.  RE: Go to Visible cells after filtered in a columnn Excel

    Posted 01-23-2021 00:10
    Thanks Nicholas. It helps i will check.

    ------------------------------
    Murali Mohan Konanki Automation Associate
    Automation Associate
    S&P Global
    UTC
    8096961984
    ------------------------------



  • 4.  RE: Go to Visible cells after filtered in a columnn Excel

    Posted 01-25-2021 04:02
    Hi Murali,

    Just in case that doesn't work out. An alternative method would be to create a Windows based object to attach to Excel, then use GSK to press the down arrow (once you've selected the header row).

    Not as elegant as using VBO, but may give you simpler alternative.

    Thanks

    ------------------------------
    Ben Lyons
    Product Consultant
    Blue Prism
    UK
    ------------------------------



  • 5.  RE: Go to Visible cells after filtered in a columnn Excel

    Posted 01-25-2021 15:34
      |   view attached
    Hi, Murali,

    I am attaching an action from our Excel VBO (Filter Worksheet & Get Filtered Row Numbers) which enables to set up a filter criteria (using Collection) and then returns collection with row numbers which met the filter criteria. Hopefully, it will help you. If you need more explanation send PM.

    Regards,

    ------------------------------
    Zdeněk Kabátek
    Head of Professional Services
    NEOOPS
    http://www.neoops.com/
    Europe/Prague
    ------------------------------



FAQ

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.



Share this post