Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am not a programmer, so apologies if I don't use the correct terms here - hope it makes sense! I have a piece of code that uses a string (Dim Storage As String)to store text concatenated from a series of cells. What I now want to do is display the concatenated text in a single cell. I have tried to use: Range("A1").Value = Storage But this doesn't actually display the text held in Storage in cell A1. When I select the cell, it remains blank, but the Formula bar shows that correct value is associated with the cell. Any suggestions on how I move the text value of Storage into A1? This is in Office 2007 under Vista, if that's of any importance. TIA Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grabbing string values from the end of a string of an unknown length | Excel Programming | |||
Replace Hyperlink Addresses Help 'Dim OldStr As String, NewStr As String | Excel Programming | |||
Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a) | Excel Programming | |||
Importing Long String - String Manipulation (EDI EANCOM 96a) | Excel Programming | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions |