resize from active cell to range?

[Armitage2k]

Hi!

how can I resize a from my active cell to a specific cell (eg. L1) and select all the cells in between?
I am using this code to select the last cell after my data (active cell is in column A).

Range("G1").End(xlDown).Offset(0, -6).Select
ActiveCell.Resize("L1").Select

Anyway, the code doesnt work since it complains about the L1. How do I code this?

thanks,
A2k

[DonkeyOte]

Perhaps you mean...

Range(ActiveCell,Range("L1")).Select

[Armitage2k]

you know, its really getting boring when you always solve my problems so fast :D makes me feel like a total goof for not figuring out myself.... T_T

thanks a lot!!
A2k