Is there a way to share or access Excel names as variables in VBA without passing them? For example using the "Offices" as the name for the number of offices and have VBA access it somehow in memory?
@EverydayVBAExcelTraining3 жыл бұрын
It can be done, but it is tricky. A little-known fact is that the personal workbook is just like all other spreadsheets. It just isn't visible. So you can write to the personal spreadsheet or any other spreadsheet for that matter. You will need to save it after you make a change.
@fatema20244 жыл бұрын
How do I combine private subs. I am trying to link the filter of a pivot table to a cell. Then repeat this for 3 pivot tables each has a filter that is linked to a cell
@EverydayVBAExcelTraining4 жыл бұрын
I think you would do this as a public sub then call all the macros. Private subs can't be called
@j.fabricioelias2275 ай бұрын
Thank you!
@EverydayVBAExcelTraining5 ай бұрын
Glad it helped
@kingscamilo4 жыл бұрын
Public and Private are of course not the same...
@rinkeshverma28804 ай бұрын
You literally can't explain😅
@EverydayVBAExcelTraining4 ай бұрын
Maybe if you send me a message I can explain it here