Workaround to go beyond 256 max. column limit

When I programmatically write data using macros, I have hit the maximum limit of 256 columns (macro stops executing after reaching the limit).

The problem would get solved if I interchange rows and columns. That is, instead of writing across columns, I could write across rows. But that would require lot of code changes as there are references like
"TempAddr = Cells(RowId, ColumnIncrement).Address"

Is there any workaround that would solve this problem without requiring changing existing cell references? Something like, at the workbook/worksheet level, you could make some settings that would interchange the layout of rows and columns.

Thanks in advance.
-NM