Understanding VBA to transfer to another workbook.

Hi, I "lost" a workbook a few years which some helpful gentleman had set up VBA to work out some complex questions. Since then I've built a new similar one with no VBA. After coming across an old hard drive I've found the older workbook with the VBA still working perfectly. I'd love to copy it to the new workbook but A) I don't understand VBA and B) some things in the new workbook have been moved, data increased, columns added etc. I wondered if I posted the VBA on here, someone might explain to me what its doing? There is just 3 modules. If I can work out what it is looking at I may be able to chnage the References and get it working in the new workbook. Many thanks.

Module 1

Please Login or Register  to view this content.

Module 2

Please Login or Register  to view this content.

Module 3

Please Login or Register  to view this content.

It's not possible to give you a really meaningful answer without the file, because we don't know what any of the data references mean.

UpdateGames doesn't do much of anything. If cell W1 contains a value, it has no effect. If W1 has a formula, it will replace the formula with the value that results from that formula. And that is a really clunky way to do it. Cleaner, without needing a variable

Please Login or Register  to view this content.

Macro1 inserts a formula into whatever cell is currently selected by the user. If the cell in the column to the left is blank the formula return a null string. Otherwise it counts on sheet ALL the number of times the value in the same row number and column 23 columns to the right of the currently selected cell is not equal to the cell to the left and also the next row down in the same column is equal to the cell to the left. I find this confusing and can't imagine the value of such a formula. I would want to see the file to understand better what's going on. (I would have used COUNTIFS for this but if this is old code it may not have been available.)

Macro2 and 3 do the same thing as Macro1, just using different columns.

R1C1 is another format for writing cell references in a formula.

The more common method is called A1. The column is first as letters, then the row as numbers

A1
BD432

Those are relative references. If you put those into a formula, then copy the formula to another cell, the references will be updated to refer to cells in the same relative position as the cell containing the formula. To make them absolute, start with a $

$A1
A$1
$A$1

If you copy to another cell, the part preceded by a $ will not change.

R1C1 is a different format for doing the same thing. Instead of column letters, it uses numbers. R gives the row number, C gives the column number. These are absolute addresses.

R1C1 = $A$1
R432C56 = $BD$432

To make the references relative, enclose the numbers in [brackets]

R1C[1] = $A1
R[1]C1 = A$1
R[1]C[1] = A1

No bother at all. That's what we're here for.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."