Copy .CurrentRegion to a variable?
The below seems to work:
Dim vVari as Variant
vVari = ActiveCell.CurrentRegion
Trouble is, I have to loop through the array and build the text string into
another variable. The goal of all this is to dump the contents of the
CurrentRegion into a cell Comment. Suggestions welcomed!
"Air_Cooled_Nut" wrote:
How do I copy the CurrentRegion into a variable? The CurrentRegion is text
and that's all I want to put into the variable (text, no formatting). TIA :-)
|