2 replies to this topic

[iguru42]

I use a lot of scripts that execute commands where the variables are grabbed from an excel sheet.

The one thing I've never been able to do is figure out how to know when I've copied a blank cell, which would mean I've reached the end of variables and would like to exit the loop.

I searched a bit but didn't find anything on point.

TIA

[Pulover]

It will probably contain just a new line, so you may check it comparing like this If Clipboard = `r`n.
Although using COM is a more reliable way to deal with excel.

[iguru42]

/me sighs.......

oh em gee, that was so freaking easy. Dunno what my problem was with that. Thanks Pulover, that's exactly what a blank cell is `r`n.