View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Assigning cell values to variables

Is this what you had in mind?

A1 = Try
A2 = this
A3 = out

=A1&" "&A2&" "&A3

Returns: Try this out

--
Biff
Microsoft Excel MVP


"Tim" <Tim @discussions.microsoft.com wrote in message
...
I need to take information from various cells and ranges in an Exel
spreadsheet and assign them to variables so that I can combine them into
one
statement. So, how do I get the information from the cell various cells
or
ranges into the variables? Or is it possible to take information,
(string
data and numeric data) from several cells and combine this information
into
one statement and have this statement appear in another cell / range of
cells?
Can anyone help? Thanks!