How to make cell value dynamic for the write cell activity

[ShenkiSinghai]

Hi,

I have a column in excel Type and Zone. I am validating for all the rows where Type is Platinum and only against that row in column Zone I want to write South in the respected cell.

Challenge is column with “Zone” name can be anywhere in the excel from A to XFD. So I want to make it dynamic.

Right now I have written the code as below which will solve my issue till column Z. But it is now working if I put Zone in column from AA to XFD.

Convert.ToChar(DT.Columns.IndexOf("Zone")+65)+ (DT.Rows.IndexOf(row) + 2).ToString

Please suggest how can we make dynamic for full excel.

Thanks,
Shenki

[jogayon001 (Jay Armand Ogayon)]

Hi @ShenkiSinghai,

you may follow on this thread.

Finding Column Index value in Excel

I am trying to find the location of a specific cell and applying that location as a value to the variable Location. The column I am looking for is the one with the column header of the variable State. In my example this column header is in Column AG. However, it keeps assigning the column as column A. I am not sure if there is something specific that needs to be done when dealing with columns with double letters etc. [image]

Good luck.