How to get a cell reference as a whole?

Kswd_b3

New Member
Hi

I want to create a page called Delete Data in an object to delete data using Excel VBO. I need to create it as a page so that I can reuse it.
The Delete Data page first selects a range and deletes the selected rows. It seems simple, but the action Select a range came requires Cell Reference. Since I want to reuse the page the cell reference is dynamic; the value always varies.

My question is is there any way to get a whole cell reference? I want to get the value like this: "A2:E20".
Or any better ideas to make the page?

Thank you in advance.
 

Attachments

  • SelectRange.PNG
    70.1 KB · Views: 32
  • DeleteDataPage.PNG
    35.9 KB · Views: 24
Top