Msgbox for reporting the value of a range....

[sssb2000]

hi,
i was wondering if anyone could point me in the right direction with this...

i have a dynamic range called Range1
i'm able to print out the address of the dynamic range....it shows as $z1:$Z5, then $z6:$Z20, etc.


within each range, the values are the same. How can i report the value of each range?

could i do msgbox Range1.value ? (that didn't work when i tried)
could i do msgbox Range1.address.value ? (that didn't work either)


help please

 

[Tazguy37]

If it's a range of values you want to output to the screen, you would have to use a loop of some type.

Example:

Dim cell As Range
For Each cell in Range("A1:B15")
   msgbox(cell.Value)
Next cell

Something like that. Does that help?

 

[martinee]

If you don't want it done for every cell in your range, and the cells all have the same value, then try this:

MsgBox Range(Left(Range1.Address, 4)).Value

This will display the value from the first cell in your range. HTH.

 

[sssb2000]

Thank you both.

i have a question for Martinee though...

what do "Left" and "4" mean in your equation?


Kev.

 

[sssb2000]

Could anyone tell me what the following code exactly means? Including what "Left" and "4" means. Please


MsgBox Range(Left(Range1.Address, 4)).Value

 

[Theadish]

I believe it's getting the first 4 values of the address starting from the left

 

[sssb2000]

Thank you very much.
I deleted the "left" and the "4" and the code did exactly what i needed. I think you were right Theadish....thank you


Also, thank you again Martinee