Thread: Setting varible to equal values of a # of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mozart[_8_] mozart[_8_] is offline
external usenet poster
  
Posts: 1
Default Setting varible to equal values of a # of cells

Is there a way of grabbing the values of a range of cells and assignin
them to a string vairable.

For example if I had RED, BLUE, WHITE in cells A1 to A3 respectively
how could I get my variable strColors=RedBlueWhite

I have tried strColors=Range("A1:A3").value and that obviously did no
work.

Assistance Appreciated

--
mozar
-----------------------------------------------------------------------
mozart's Profile: http://www.excelforum.com/member.php...fo&userid=1331
View this thread: http://www.excelforum.com/showthread.php?threadid=53311

Reply With QuoteReply With Quote