Create a table that is sized based on user input in Excel?

Hi Friends,

I am trying to create a macro to make table in excel where the size should be user input. For .e.g. if I say 2 rows and 3 columns then a table should be created in the separate sheet. And i want the name of the sheet to be the Question number that the user will input.

Can you help me with the VB code in the attached Excel.

Regards,
Hema
macro.xlsx

Hi Parth,

This is nice, it creates borders around the cells selected. The macro i am looking out for is when I enter the no. of rows and no. of columns it should create a table in another sheet. So in the excel you I have attached when I enter the values it should create a table structure in another sheet with sheet name as Q1.

I hope it clarifies.

Thanks,
Hema