Range using Offset

[nikki]

is it possible to specify a range using offset's? as each month the columns required will change, hence i require a less explicit way (than A29:A34, for example) to tell it where to copy and paste from and to.

does that make sense?

Thanks

[MaximS]

of course you can:

[VBA]
=OFFSET(A1,1,MONTH(NOW()))
[/VBA]

Above will give you value of cell A1 plus one row and nine columns ("J2").

Adjust as you like.

[Bob Phillips]

=A29:INDEX(A29:A41,MONTH(TODAY()))

non-volatile

[nikki]

Thanks very much