Hey everyone,
I created a macro for a workbook that enables me to make a pivot table from a dynamic range. The difficulty I am having is enabling this macro to also properly SHADE and BORDER my pivot table dynamically as the data changes.
I tried just using the format cell feature, but it only applies it to the rows and columns I have selected. Is there something I am missing?
Also I am required to save the macro file to text, is there a "Best" approach to this, I had trouble just copying the code to text and getting it to work.
To check if I can use the macro from text do I just start and record a new macro and paste it in, or is there a different process?
Thank you all ahead of time I appreciate the help!
I created a macro for a workbook that enables me to make a pivot table from a dynamic range. The difficulty I am having is enabling this macro to also properly SHADE and BORDER my pivot table dynamically as the data changes.
I tried just using the format cell feature, but it only applies it to the rows and columns I have selected. Is there something I am missing?
Also I am required to save the macro file to text, is there a "Best" approach to this, I had trouble just copying the code to text and getting it to work.
To check if I can use the macro from text do I just start and record a new macro and paste it in, or is there a different process?
Thank you all ahead of time I appreciate the help!
