I have never written a macro nor written much code before. So to begin with I would liike to know if it is even possible to write a macro that will change the width/height of cells and merge some cells. I also want to be able to have it allow the user to enter text into the cells and it will change te text size/bold text depending on which cell the tet is entered in.
Idealy, running the macro would start a prompt that asks for the cell width/height and content, 1 by 1 until the table is complete. The "title" cell will have a larger bolded font adn merge cells to create a "title cell" above the rest.
EXTRA:
once this macro is run(cells formatted and the outcome is an excel worksheet that looks like a table with data entered) the worksheet will be usd in a program called XL2CAD in the AutoCAD 2019 design software. The data should come through to AutoCAD looking like a table with data entered.
I have already set up the AutoCAD side of this process, i just want to speed up the process of formatting the excel sheets because there are hundereds of table that need to be created.
any help is appreciated, Thank you.