98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA code to convert spreadsheet content to dynamic arrays
VBA code to convert spreadsheet content to dynamic arrays
Resolved · Low Priority · Version 2016
Tue 21 Aug 2018, 16:59Delegate Alek said...
Alek has attended:
Excel VBA Advanced course
VBA code to convert spreadsheet content to dynamic arrays
In the course it was suggested we should start using dynamic tables in all workbooks. Is there a way to automate process of converting spreadsheet content to dynamic to allow autoupdating of tables, charts etc.
Wed 22 Aug 2018, 11:52Trainer Jens said...
RE: VBA code to convert spreadsheet content to dynamic arrays
Hi Alek,
Thank you for the forum question.
Dynamic tables are amazing to save time, but to automate creating them is not easy. We need to be able to identify the ranges we want to convert and each table need to have unique name.
I have created an example. Please find attached file.
You will find the attachment below my signature. If you cannot see it please wait 5 minutes and refresh your browser.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
Wed 29 Aug 2018: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Open Worksheets At OnceWhen multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option. |
