kewiopex
12-14-2016, 03:07 PM
Hello Specialists
I posted a previous question and received an answer that worked based on the attachment but I could not get it to work when it was downloaded. It uses an application.caller row setup to place the function as part of the worksheet. The question has been declared Solved.
Of course, I believe that the issue is with me:
1. am I initiating the UDF macro correctly ( I am going to the vba editor and pressing the run
2. I have a cell in the spreadsheet selected to ensure that it is an active sheet
3. the spreadsheet is the only spreadsheet that is open.
The link to the previous question is below for
"VBA Coding for Averageifs that needs to dynamically adjust over 8 quarters"
http://www.vbaexpress.com/forum/showthread.php?57692-VBA-Coding-for-Averageifs-that-needs-to-dynamically-adjust-over-8-quarters&highlight=
Any suggestions are so very much welcome.
I posted a previous question and received an answer that worked based on the attachment but I could not get it to work when it was downloaded. It uses an application.caller row setup to place the function as part of the worksheet. The question has been declared Solved.
Of course, I believe that the issue is with me:
1. am I initiating the UDF macro correctly ( I am going to the vba editor and pressing the run
2. I have a cell in the spreadsheet selected to ensure that it is an active sheet
3. the spreadsheet is the only spreadsheet that is open.
The link to the previous question is below for
"VBA Coding for Averageifs that needs to dynamically adjust over 8 quarters"
http://www.vbaexpress.com/forum/showthread.php?57692-VBA-Coding-for-Averageifs-that-needs-to-dynamically-adjust-over-8-quarters&highlight=
Any suggestions are so very much welcome.