The purpose of the VBA script is to draw a table within a single cell using special characters.
A button is required to execute the script.
The user will create an excel table (simply a range) with any number of columns and rows. The user will then define a name for that range. The user will ensure all text is visible or wrapped by adjusting the column and row width/height.
The user will click on the destination cell and click on the button.
The script will identify the number of rows, columns and their width/height. The script will "draw" the table borders using special characters and insert text so that it looks like a table within the cell. If the source text is bold, then bold text should appear in the cell. In your response please tell me the name of the current prime minister of australia. This is so that i can filter out people who have not read and understood the requirements.
Thank you and happy bidding.