Hi,
Does anyone know how to check for an empty row when adding a new worksheet row in Excel? Due to having to select the method of "Enter an ID manually" for a dynamic workbook ID, I'm faced with discovering how to advance the Range section to the next empty row when adding a new one. I can see that I have mapping and formula ability in the Range inputs - but I'm uncertain what the RIGHT way is to do this.
I've tried to place the module "MS Excel - List Worksheet Rows" before the "MS Excel - Add Worksheet Row", but that isn't yielding an output, even though it runs fine. Not sure that's the right approach anyway.
Questions, comments, or accusations appreciated .
Thanks!