VBA Fill

[biggsy]

Hi all,

Hope someone can help......

I need to try and fill a series of col's with a odd formula

The formula is quite simple: =A$1 however i need to repeat this 5 times so the next cell down is =A$2, =A$3, =A$4 and finally =A$5.

Pretty simple so far! However, the bit that goes wrong is when i want to change the next cell to read =B$2 and repeat the same for the next 5 cells and then C and so on......

For some reason, I cannot get excel to do this and to type this in onto 5000 rows will send me up the wall!

Does any one have any hints on how to acheive this. If u r local I will buy you several Pints!

Ta

Biggs

[mrice]

Not sure if I've understood this totally correctly but it sounds like you need a combination of the indirect function and the cell function

If you paste this

Please Login or Register  to view this content.

into E1, copying it down will link to the contents of A1,A2,A3,A4,A5,B1,B2,B3,B4,B5,C1,C2,C3,C4,...etc.

Does this help?

[biggsy]

I will give it a try in the AM......

Thanks much apreciated, will let you know!