I am doing a search on a web site for several items. Depending on the item the search may return 1 search result, 2 search results or many search results. I am using Get Text to copy the description of the first three search results and set the property to Continue on Error to True. On items that have 2 search results or less it is copying the description from the previous item above. I think its using the variable from the previous item instead of recognize that their is no description and leaving it blank. See sample below, for the second item “Red Delicious Apple” it only has 2 search results. It should leave cell D3 blank but instead it copies cell D2.
How can I make it leave cell D3 blank since their are only 2 results?
Can I make it type something when Get Text errors out?