Allocate array with values from different ws

[samot79]

I am trying to allocate an array with values from a worksheet in my workbook.

Sheet in question is a variable named CurWs and I have expected value in Watches window but this line of code throws me an error.

Please Login or Register  to view this content.

Have I specified range wrong?

[AlphaFrog]

Deleted code

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

Or this...

Please Login or Register  to view this content.

[samot79]

Problem is that I set CurWs in a private sub. But I have made it global by

Please Login or Register  to view this content.

In a module.

When I run private sub CurWs is assigned value but gets value <out of context> when private sub is finished.

Please Login or Register  to view this content.

Can you see why CurWs isnt global with this code?

[AlphaFrog]

You are using two different variables.

You declared the public variable CurWs

The code sets the worksheet to CurrentWs

[samot79]

mon dieu..

[AlphaFrog]

De rien .