Hi,
I have a table with around 12 columns - of this only 6 are visible - have hidden rest of the columns by formatting with dark shades.
This table is a template and gets copied when a new sheet is created.
When the table gets copied to a new sheet and a new row is added through...
I've written a few macros using VBA and always refer to a particular column using
Cells(x,y) or ActiveCell.offset(0,x)
However, when some new fields were added in-between or some fields were removed from the base file - everything went haywire
Is there anyway I can change my coding style...