| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
i.Value, i.Text, Or just i?
I'm using a simple loop like this to replace certain values in a
range: For Each i In iRange If i = "NYCITY" Then i = "NYC" If i = "FTBENNING" Then i = "FORTBENNING" '... Next The values will always be text, so is it more efficient to use i.Text? Or maybe i.Value? Or is it best to just leave it as i? Thanks, -- Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming | |||
| Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit | Excel Programming | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
Threaded Mode
