No problem. As for deleting the last row, have you tried e.g. to use the activity ‘Select Range’ and then another ‘send hotkey’ activity, where you put ‘Ctrl’ +“-”. You may also use ‘Remove data row’, see also:
To find the last row you may use ideas from this thread:
Hope this helps.
Anil_G
ashokkarale
Yoichi
Jon_Smith
A_Learner
ewanc1
Sylvain_FARNAULT_131
CHEN-CC
Eric_Alvarado
azeem_rosli