Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
myCell = CStr(SomeDigits) ?
I was looking at a spreadhseet populated with a data query. It has a series
of cells that are a code that, in present case, happens to be 5 numeric digits. As returned by the query, ISTEXT() is TRUE. It is not preceeded by a '. It is cell formatted General (not Text). But the value in the cell is text not numeric. Text is OK. So I'm trying to programatically put this value in a cell in another sheet. I want it to be ISTEXT(), not proceeded by a ' and cell format General. Just like the query creates. I've compared properties of the two cells and nothing is different besides the type of Value2 being Variant/String in one case and Variant/Double in the other. Yet just assigning .Value2 = CStr(myStringOfDigits) still results in a Double in the cell. Surely if the data query can put a string in the cell as a string, VBA can do the same??!? Thanks in advance for any thoughts! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ListBox1. add item myCell.entirerow | Excel Discussion (Misc queries) | |||
myCell.Row? | Excel Programming | |||
myCell.Formula application unknown object error | Excel Programming | |||
Problem with leap-frogging myCell Range | Excel Programming | |||
Value of next visible mycell within a rng | Excel Programming |