Hi guys, I want to make my Lookup DT dynamic - meaning - I want the Target columnindex to dynamic loop through all the columns and gradually enter data into my excel file. I tried to use the following: cint(DTSelEq.Rows.IndexOf(row)+3) - but it throws an error. Kindly guide how to work it out. […

cint(DTSelEq.Rows.IndexOf(row)+3) This is your first code. How about revert your code to This. You said row is member of DTSelEq. So this code will make sense. What you need to check is that DTSelEq.Rows.IndexOf(row)+3 is within the size of columns of DTCrisil as I said before.

How to create a dynamic Lookup Datatable?

Help

yuji.katayose (Yuji ユウジ）) September 14, 2020, 3:50am 3

BTW, Write Rante activity is much faster than writing into cells one by one.

Topic		Replies	Views
Write in specific column based on a row Academy Feedback datatable , excel , uiautomation , activities , string , question	34	10230	April 30, 2020
For each row と lookup range Ask in Your Language datatable , activities , question	12	1459	December 26, 2019
How to find the end row (dynamically) in any column in a DT Learning Hub	2	986	April 24, 2020
Write range ...step Activities excel	8	419	October 28, 2023
Lookup Data Table on Multiple Columns Help datatable , activities , question	4	9049	December 19, 2019

How to create a dynamic Lookup Datatable?

Related topics