Tables in Excel

[Karel12]

Hi there, I have created a table in excel but want a macro to be able to add another row to the table, and also one to add another column.

Could anyone assist me with this, or point me to a resource that can?

Im quite a newby with using VBA and havent got much experience using tables.

Regards
K

 

[Smitty]

Welcome to the Board!

This is where the macro recorder is your friend. Just record a macro adding the row/columns and see what you get. Feel free to post it back here for someone to clean up, as the recorder isn't always the most efficient tool, but it's a great learning resource.

HTH,

 

[Karel12]

Hi, sorry I think I wasnt that clear, I want to insert a new column/row from a template of a row already set, this will have all the formula's in.

Im trying to create a mark-book system which will need new tasks added in the columns, and new pupils to be added in the rows.

Would a screenshot be useful?

 

[Smitty]

Would a screenshot be useful?

Sure, check the link in my sig line.

 

[Karel12]

Sorry Im not very good at this, how would I upload a screenshot?
Is it through SkyCloud from your sig?

 

[Smitty]

The link will lead you to a SkyDrive folder, where you'll be able to download a copy of the board's HTML Maker. With that you can post a shot(s) of your sheet.

There's also a Word document there explaining how to install and use it - It's a very simply add-in.