Is there a way to select dynamic range in Excel?

[kaderms (Kader)]

Okay. Now I get your problem.

Not all Excel Activities allow you to specify empty range, for selecting the entire used range. (Hope this changes soon )

You can refer the documentation to figure it out - Compare the below two activities and you’ll get the difference.

Create Table

Read Range