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
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