how to use dynamic region in excell application .?

[PrasadM]

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

[JiriPospisil]

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