Well, like I said, I'm a total novice at this stuff =P

I was talking more about what caused my problem to begin with, that th
method I was used to using in identifying a particular range simply di
not work when referencing another sheet.

The Sheets(2).Colums(2).Delete is exactly what I wanted to do, excep
in the format of :

worksheets(2).Range(Cells(I, 1), Cells(J, 5)).copy


I guess I just don't know enough yet to see why the method you laid ou
(i.e. diminsioning ranges instead of using them directly) is mor
flexible than how I though the code would have worked.

Anyway thanks for the time and the help. The overall development o
this app is rolling along much smoother now that I know the prope
syntax (if not understanding the why of it!) to reference non-activ
sheets and ranges properly

--
Ouk
-----------------------------------------------------------------------
Ouka's Profile: http://www.excelforum.com/member.php...fo&userid=2398
View this thread: http://www.excelforum.com/showthread.php?threadid=38894