How to declare "c" For Each c In Range()

[sjh]

Hi,
How should I declare "c" in the following code?

For Each c In wSystemData.Range("Scenario&quot
'do stuff
Next c

Thanks!

 

[combo]

As Range. When you work with any combination of cells (also row, column or single cell) - this is always Range.

combo

 

[BrainB]

You have use a rather "lazy" line of code, which in full would be :-

For Each c In wSystemData.Range("Scenario&quot.Cells ....

so you can use things like :
x = c.Value



Regards
BrianB
** Let us know if you get something that works !
================================