| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA automatically change text format into general format?
Hi,
I've a macro which can copy cell(s) containing formula in text format into other cell(s). I want to activate these formulas automatically when they are in the destination cell. For the time being I have to go in each cell and activate the formula by hitting enter. Is it possible to do it automatically, something that I can add at the end of my macro ? Thank you Nic. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA automatically change text format into general format?
Try setting the formula of the destination cells to the text of the
host cells like this: Range("A1").Formula = Range("A2").Text HTH Die_Another_Day Nicawette wrote: Hi, I've a macro which can copy cell(s) containing formula in text format into other cell(s). I want to activate these formulas automatically when they are in the destination cell. For the time being I have to go in each cell and activate the formula by hitting enter. Is it possible to do it automatically, something that I can add at the end of my macro ? Thank you Nic. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA automatically change text format into general format?
Hi thank you
so simple and it works, cool Die_Another_Day wrote: Try setting the formula of the destination cells to the text of the host cells like this: Range("A1").Formula = Range("A2").Text HTH Die_Another_Day Nicawette wrote: Hi, I've a macro which can copy cell(s) containing formula in text format into other cell(s). I want to activate these formulas automatically when they are in the destination cell. For the time being I have to go in each cell and activate the formula by hitting enter. Is it possible to do it automatically, something that I can add at the end of my macro ? Thank you Nic. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| General Text format automatically get changed to DATE | Excel Discussion (Misc queries) | |||
| Change cell format from text to general on the fly | Excel Discussion (Misc queries) | |||
| excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
| Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
| Change General Format to Currency Format | Excel Worksheet Functions | |||
Linear Mode
