Assign cell as range to another...as range either

[MoonAlert]

Hello,

How can I assign a cell as range to another one as range either?
I need to keep the range of that cell to use later on.

The following sample code gives me an error.

Please help.
Thanks!

Please Login or Register  to view this content.

[millz]

Hello MoonAlert, please take some time to read the forum rules if you haven't. You should post code within

Please Login or Register  to view this content.

[/noparse] tags.

As for your problem, you have declared cel1 as a String.

[MoonAlert]

Thanks for answer.
That was a mistake when paste a sample code here...I declare as range and get the error with it.

Please Login or Register  to view this content.

(Sorry break that rule!)

[millz]

So now the problem is because cel2 is Nothing, you have declared it but it's not instantiated with any range/cell.

If you want to store cel1 in cel2, it should be:

Please Login or Register  to view this content.