Select the whole range in excel

I would like to select the whole written range in excel .
as the range is dynamic based on the report generated.

in select range activity i have to specify a specific range .

can any one help

to read the entire sheet use “” in read range

hi @FMK,

If you want the Range to use in the select Range.

  1. Read Range - This is give you a DataTable with all rows in Sheet.
  2. Get Row Count by : DT.rows.count - This will give you the number of rows.
  3. Take a stringVariable Called Range and assign it value as A1+M+dt.rows.count.toString - This will give you the dynamic Range - Here M is Column - Can vary in your Case
  4. Use the Range in Select Range.


Mukesh

2 Likes

this worked , thank you very much

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.