Need Help!! For each loop not executing

[droid3]

Hi All,

Below is my macro code to get the items from my pivots present in different sheets.

Please Login or Register  to view this content.

Can anyone please help what I am doing wrong? Pivot_One and Pivot_Two is made from Power Pivot model.

Thanks!!

[dominicb]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(I have added them for you this time, but please bear in mind when making future posts.)


"For ... Next" loops need a For statement and a Next statement to complete.
Your code doesn't seem to have a Next clsoing statement, or perhaps you're using nested loops and your Next statement come further down, beyond what you're showing to us.

If you're used to PHP, that code doesn't need a Next statement to complete. VBA does.

HTH

DominicB