How to get Column Range from Excel



Hello to all,

I have a problem that I can not solve.

In practice I would like to get the range of a column starting from another specific column.

Example: I tell the robot to read column “B” (or “Age”) and I would like to get the range of the “Name” column (which in this case is “D”)

Someone could help me with my problem, kindly.

thanks to the whole community,



  1. Use read range to read from Column B
  2. Check the Length of the data
  3. Set range to column D as D1:D(length of column B)

Hope this helps!


Thank you so much for the answer @Madhavi

… but I know you misunderstood my request.

what I would like to get as a result is the letter in which the “Name” column is located:
in my case it is in column D … but I do not know in what column is “Name”, so I would like to find the index “D” as a result when I ask the robot to look for the column in it is the word “First name”


Hi @momi_fede

I think this might be useful for you.