I have a lot of code in the form;
Sheet4.Range("S" & iCount).Value = Range("B20").Value
Sheet4.Range("T" & iCount).Value = Range("C20").Value
Sheet4.Range("U" & iCount).Value = Range("D20").Value
Sheet4.Range("V" & iCount).Value = Range("E20").Value

works fine but I can't easily add columns to the sheet as all the
references are then wrong ! Bad design, I'm sure.

What can I do about this - can I reference columns differently ?

Any other ideas ?

Help would be most welcome.

Thanks