Naming Range Different Sheet

[pezalmendra]

Hello,

Im finding some problems in my code when trying to name ranges that are in a different sheet.

Running the code in Sheet1 I want to execute the following code:

Please Login or Register  to view this content.

I don't know why but this code will only work if I run it in Sheet2 and not in Sheet1 that is where I would like it to do.

Thanks for the help.

Kind Regards,

[Norie]

You need a worksheet reference for Cells as well as Range.

Please Login or Register  to view this content.

[MarvinP]

Hi pezalmendra,

When I record a macro to do what you are asking I get the following code:

Please Login or Register  to view this content.

I wonder if this code (recorded using 2013 excel) will work in your 2003 VBA?

[pezalmendra]

Hello again and thanks for the reply,

Couldn't make work any of both codes... Maybe it helps if I point out that Im running this code via a

Please Login or Register  to view this content.

The thing is that if I run the macro in the same sheet where I want to name the range (Sheet2) the code will work. If I run the code from a different sheet (Sheet1 in this case) it will give me an error.

[Norie]

Can you post all the code and explain how it doesn't work?

[pezalmendra]

Hello Norie,

Here is the code:

Please Login or Register  to view this content.

Thanks,

[Norie]

So you didn't try the code I suggested?

[pezalmendra]

Yes, I tried it but with not success... I thought you wanted me to post the initial code I wrote.

[pezalmendra]

Hello again!

I manage to solve the problem, just had to reference also in the cells inside the range the Sheet where the cells are:

Please Login or Register  to view this content.

Thanks for the help!!

Regards,

[Norie]

The code I posted is just another way of writing that and it does work.

Please Login or Register  to view this content.