| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying cell contents
I wonder if it's possible when adding data to cells using VBA, to have one actual value (as seen in the Formula Bar) and another value that is displayed in the cell? I tried the Range.Value and Range.Text properties, but Range.Text won't work.
Range("D2").Value = "value" Range("D2").Text = "text" Row 2 gives error 424, object required. What kind of object does Text want? Gustaf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying cell contents | Excel Discussion (Misc queries) | |||
| Displaying contents of Active Cell | Excel Discussion (Misc queries) | |||
| Displaying Cell Contents | Excel Discussion (Misc queries) | |||
| Help with displaying the contents of the last populate cell. | New Users to Excel | |||
| Displaying contents of cell on different spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
