Hi,

Put this in a cell and drag right and you will get a1, a2 etc

=INDIRECT(ADDRESS(COLUMN(A1 ),1))

Mike

"Bazy2k" wrote:

Hi Guys

I want to drag my formula across a row but the items i want them to link to
are displayed horizontally?

ie.. i want to drag the formula across and sequentially increase like this.

=a1,=a2,=a3,=a4,=a5,=a6 and so on across, without having to write it obv!

Can this be done?