Coding Explanation Help Request

Hi,

I was hoping someone would take pity on me and help explain what's going on in some code I've been reviewing - i literally have no idea

The coding is from an application that uses a form to add a new set of data to a table. I've been teaching myself VBA so have been breaking down and building my own from scratch and some of its got me baffled.

Once the user has entered the data and clicked the submit button, it runs a Sub which calls three other Subs: WriteToTable, ExpandTable & SortTable.

WriteToTable I've got (just) as it just adds the entered data to the next available blank row. I've not looked too hard at SortTable, but that appears to be just picking a column and sorting the data based on that criteria. What I don't get is the commands in ExpandTable.

The Code is:

Please Login or Register  to view this content.

What on earth is going on here???

I can't find a description i can understand of RefersToR1C1 anywhere so haven't got the foggiest about what this line is doing

The Table its expanding is currently A1:D1 when no data is held. When data is added it fills row 2; so I'm assuming Its somehow telling it to add the new row to the Table and "expand" it so its now held as A1:D2?

If someone could put what's happening into plain English for me it would be appreciated.

Thanks

Hi Mike

Thanks for the reply and the links. I now know the R & C relate to Row and Column

What i Don't get is why it's being used twice?

Ignoring the last line for a second, which appears to just be sorting the data in the table based on the values in Column B, why is the other line referred to twice?

Please Login or Register  to view this content.

I don't understand what is happening in the first line and what the change from "("A1")" to "("Table").CurrentRegion.Address)" is doing.

I'm clearly naive because as far as I'm concerned, the activeWorkbook is just defining which workbook is being referred to; the .Names is referring to the Names already in that workbook; & the Add method(?) is adding to something already defined which in this case is the Name "Table".

After that I'm stuck - Any ideas?

Originally Posted by romperstomper

It is a pretty weird way of writing it, but essentially you add a defined name pointing to A1, then immediately resize it to include the whole region around A1.

really? the workbook already has a Named Object called table, so if that code is adding one of the same name; what happened / is happening to the original one? is it automatically replaced / deleted?

Also...

How does currentRegion work? Am i right in assuming the region is defined as the selected range and continuously spreads out as long as an adjacent cell has a value within in?

Thanks again Mike for your help on this one.