Discussion board where members can get started with QlikView.
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
Please help me
Go to Solution.
In vbscript you don't have direct access to the excel enumerations, so xlUp can't be used. Try its value -4162 instead:
ExcelWB.Activesheet.Range("A65536").End(-4162).Row to find the last row in column A.
Edit: There's a list of enumerations on msdn. Or you can look them up in the object browser of the vba ide of excel.
Thankyou it's working fine
can you please let me know how i could get to know all such enumerations for Qlikview Macro's please ....
Can you help me in finding last column in a given row
below code is throwing some error
myCol = Obj_XLTemplate.worksheet("sheet1").Range("A1").End(-4161).Column