Call one function from another function in excel VBA

Hello All,

I have 2 functions in my excel VBA.

1. Sub InsertPivotTable() - This function is creating pivot table in a new worksheet. Sheet B

2. Sub Copy_Pivot() - This function is copying pivot table from new sheet B to existing Sheet A.

Both the functions are working fine separately. But I have 2 macros for this.

Is there a way I can call Copy_Pivot() in the InsertPivotTable() function.

I added 'Copy_Pivot' towards the end. But this is not working and adding the function is not creating pivot table even.

Can any one please let me know what is missing here.

Please Login or Register  to view this content.

Just copy paste the codes you used inside the sub Copy_Pivot() macro ,to the end of the Sub InsertPivotTable() . It will work .!

Make them functions, not subs on specific work sheets.

Hello,

Thanks for the reply. I tried giving the code in the main sub. But it did not work. This is the code to copy pivot from 'PivotTable' sheet to 'Check' sheet.

Please Login or Register  to view this content.

Hello, Thanks for the reply.

Can you please let me know what the return value would be if I make it a function instead of Sub