https://community.blueprism.com/t5/Product-Forum/how-to-use-dynamic-region-in-excell-application/m-p/84191#M35367 hi, as I am trying to perform filter operation in excel using dynamic region ,failed to capture the right image . appreciate someone's assistance . thanks in advance Thu, 17 Mar 2016 17:25:00 GMT PrasadM 2016-03-17T17:25:00Z https://community.blueprism.com/t5/Product-Forum/how-to-use-dynamic-region-in-excell-application/m-p/84191#M35367 hi, as I am trying to perform filter operation in excel using dynamic region ,failed to capture the right image . appreciate someone's assistance . thanks in advance Thu, 17 Mar 2016 17:25:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-use-dynamic-region-in-excell-application/m-p/84191#M35367 PrasadM 2016-03-17T17:25:00Z https://community.blueprism.com/t5/Product-Forum/how-to-use-dynamic-region-in-excell-application/m-p/84192#M35368 Hi Prasad, I created new page in MS Excel VBO called Current Region Range with Code Stage inside (it will not work as separate BO as there is some initial code in MS Excel VBO Initialize page) Put this code into Code Stage: Dim ws as Object = GetWorksheet(handle,workbookname,worksheetname) ws.UsedRange.Select MyRange = ws.UsedRange.Address(false,false) Code stage (and therefore whole action) needs to have these inputs: handle,workbookname,worksheetname and this one output: MyRange Mon, 04 Apr 2016 16:17:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-use-dynamic-region-in-excell-application/m-p/84192#M35368 JiriPospisil 2016-04-04T16:17:00Z