Thanks, guys. While I have had to write some lengthy code to handle a
series of conditions or workflow steps, I've never needed to do any really
complex coding nor work with multiple workbooks. I've always tried to
encourage the use of Excel as a reporting tool with an SQL data source, not
as a database; and in my industry (pipe, valve & flanges) there aren't many
complicated calculations.

Still, I'll keep this in mind for the future and do the research suggested
by Chip.

Thanks, again for your time.

Ross


"Ross Culver" wrote in message
...
Yeah. I never use objects, only cell/range references and variables. In
fact, if you would and when you have time, briefly explain the why bother
to use an object at all? I need to learn something new today.

Ross

"carlo" wrote in message
...
Thank you all for replying.

@Ross:
the Set is mandatory because copy_rng is an object!

Carlo


On Nov 29, 11:12 am, carlo wrote:
Thanks Basilisk96

I just tried a little bit more and i found out following:
'-------------------------------------------------------
dim copy_rng as range
set copy_rng = worksheets("sheet2").range("A1:T1") '<--works
set copy_rng = worksheets("sheet2").range(cells(1,1),cells(1,20)) '<--
works not
set copy_rng =
worksheets("sheet2").range(worksheets("sheet2").ce lls(1,1),worksheets("shee-t2").cells(1,20))
'<-- works
'-------------------------------------------------------

i have to give Excel the parent to all the cells!
I thought the cells() in the range object are just for the addresses
sake, but I was wrong, they have to be on the same sheet, so I need to
specify the parentsheet for every cell.

thank you very much, sorry for the confusion.

cheers and thanks

Carlo

On Nov 29, 11:06 am, Basilisk96 wrote:



On Nov 28, 8:52 pm, carlo wrote:

Do I become senile? This thing is driving me crazy!

I recall, I had this problem once...
You're fine, you just need some time AFK for a fresh perspective ;-)

Think about this, and you will see the light, I promise:
Who is the parent of your Cells() calls? That's right, qualify them
explicitly, and it will work in all cases.

;)
Cheers,
-Basilisk96- Hide quoted text -

- Show quoted text -