View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Air_Cooled_Nut[_2_] Air_Cooled_Nut[_2_] is offline
external usenet poster
 
Posts: 26
Default 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 :-)