Hi all,
I've got confused with many range formats. In Help site of MS Office
2003 told that these 2 types of range is the same:
ex1: Range("A1:C20")
ex2: Range(cells(1,1),cells(20,3))
However I've found that they are different in using.
ex1: sheets(1).Range("A1:C20").copy(sheets(2).range("A1 ")) -- It's
working
ex2:
sheets(1).Range(cells(1,1),cells(20,3)).copy(sheet s(2).range("A1")) --
fail
Object-defined error????
I really dont know what is the different thing here? The same case with
others functions using with range?
Anybody meet the same problem like me? plz give me some hints or show
me the solving? thanks a lots!!!
--
azzura
------------------------------------------------------------------------
azzura's Profile:
http://www.excelforum.com/member.php...o&userid=37450
View this thread:
http://www.excelforum.com/showthread...hreadid=571156