Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning cell values to variables
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning cell values to variables
Do you mean
A1 = 'Assigning' B1 = cell C1 = values In D1 you need 'Assigning cell values'..If so use CONCATENATE() function or simply =A1&B1&C1 If this post helps click Yes --------------- Jacob Skaria "Tim" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning cell values to variables
Sub tim()
Dim s1 As String, s2 As String s1 = Range("A1").Value s2 = Range("Z100").Value End Sub -- Gary''s Student - gsnu200856 "Tim" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning Values to Symbols | Excel Discussion (Misc queries) | |||
assigning values to one cell which will change the formula in anot | Excel Worksheet Functions | |||
Assigning point values? | Excel Worksheet Functions | |||
Assigning cell values to return a number | Excel Discussion (Misc queries) | |||
Assigning cell values to return a number | Excel Discussion (Misc queries) |