Delete rows from Cell (A) To Cell (B)

Help
1

Dears,

I have a list of items in one column in excel fine, and given random cells : A & B, I want to delete all items between Cell A and Cell B. How to achieve this? .Here’s an example :
image Example.xlsx (9.9 KB)

Thanks in advance

2

Hi @hsendel

You could use a write range activity with the range set to "A:B" and set it to write a blank string.

Is this what you were hoping for? Or did you want to completely delete the rows?

3

Thanks nlee1131 for prompt feedback.
YES, I want to delete all rows between cell A and Cell B

4

Have you looked into this activity yet?

5

I need to get the following column at the end :
image

6

Would something like this work?

deleteRange_hsendel
deleteRange_hsendel1557×564 22.2 KB

7

This is nearly what I want, remains only one point: my range to be deleted is not static, it’s varaible, means, cellA and CellB are changing, need to be declared as inputs, Is my scope clear?

8

For example, I say : delete rows from cell with ( Last Digit is 6) and Cell with ( Last Digit is 2).

9

Could you try this syntax: """" + cellA + ":" + cellB + """" where ‘cellA’ is the first cell and ‘cellB’ is your second cell?

10

where to try this ? in range activity in your example?

11

Yeah

12

UnfortunatelyExample.xlsx (9.9 KB) Sequence.xaml (6.9 KB) , it’s not working

13

Hi @hsendel,

If it is dynamic , use find activity in below package . It returns the cellinfo based on that you can delete the row.

Regards
Balamurugan.S

1 Like