Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Feb 23 at 8:42 PM How did you create the macro? Did you record it and then edit the recording to perform the same operation multiple times or did you write it from scratch?
In either case, I assume you have a loop of some sort in the macro in order to loop through the product types. If so, if you don't get data back on a particular type (check the return code) instruct the macro to continue without processing. When the loop runs out of input data, it should stop automatically.
Lou
| | | ---------------Original Message---------------
From: GhadaElMalky
Sent: Sunday, February 23, 2014 8:32 AM
Subject: Creating a Macro Excel
Hi
i working on an excel macro that filters a specific product type and puts it in it's corresponding tab and then takes all the other product types and put them in another tab
i did the recording and it is working
however if that product type i am filtering on doesn't exist the macro does't work
so i need to tell the macro to proceed adding the other product types to their tab and leave the tab specified for that product type empty
any solution for that? |
| Reply to this email to post your response. __.____._ |   _.____.__ |
