How to refer to general columns

[mumair]

I have two examples of snippets of code:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Both areas would be incorrect if I added another column into the spreadsheet. However, I would like to do this without having to change the code every time I add a new column. Any thoughts?

[kev_]

You cannot make VBA bullet proof to structural changes in the worksheet - protect the worksheet and ensure that anyone with password understands ramifications

One trick is to use named ranges.
Eg name cell A33 "TaxRate" and use Range("TaxRate") in the code -instead of Range("A33")
When you insert 2 columns (A & B), A33 becomes C33
Range("A33") gives wrong result but Range("TaxRate") still works because it's RefersTo range automatically changed to C33 when you inserted 2 columns

The best advice is to nail the worksheet structure - get it right and stick to it - and avoid the temptation to tinker once the VBA is written. I prefer to add an extra worksheet linked to the nailed down one (still with its VBA working!) when someone asks for a new "flavour" of report