How can i get first cell from range?

[heyium]

Hi!

I have a multi-table excel. First I find the table range to use with the “Get Table Range” activity. Then I want to write text in the first row of the 4th column with “Write Range”, but the cell I will start typing will constantly change. What should I write in the “cell” part of the “Write Range” activity?

How can i get first cell from range ?

B4:E19->E5
G4:J19->J5
.
.
.

Thank you,

[Anil_G (Anil Gorthi)]

Hi @heyium

You can use excel scope and then find/Replace and find ‘PRE’ which is there at start of all tables. This will give you the list of all the cells those are you start points

cheers

[heyium]

hi @Anil_G
is there any other method?

[Gokul001 (Gokul Balaji)]

HI @heyium

You can also try with Look up Range activity to get the Pre Range in the Excel

Check out the video link

UiPath Tutorial | Uipath LookUp Range

Regards
Gokul

[heyium]

@Gokul001 Thank you!