You want to use Ranges:

Dim L as Long, M as Long, N as Long O as Long
Dim Rng as Range

L = 3
M = 3
N = 100
O = 100

set Rng = activesheet.Range(cells(L,M),cells(N,O))

now Rng contains a range of cells on your sheet.


--
Dnereb


------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=508743