3 Replies Latest reply: Jul 23, 2013 11:16 AM by Sriharsha Pillarisetty RSS

    How to find Last row in a given column of excel sheet using Qlikview macro

    Sriharsha Pillarisetty

      Hi All

       

       

       

      I am very new to Qlikview 

       

      Is there any way to find the last used row in a given column of excel sheet by using the Qlikview macro I used several VBA code as well as the vbscript codes

       

      some of them are listed below but none of them worked

       

      1. ExcelWB.Activesheet.UsedRange.Cells.Find("*", [A1],,,xlByRows,xlPrevious,,,).row
      2. ExcelWB.Activesheet.Cells(.Rows.Count, FirstCell).End(xlUp).Row
      3. ActiveSheet.Range("B:B").Cells.Find("*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row

       

      Please help me

       

      Regards

      Harsha