| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep function result after removing referenced column
Thanks. That worked.
"Stefi" wrote: Select TO column Copy PasteSpecial/Values (into the same TO column) Regards, Stefi €˛Charles in Iraq€¯ ezt Ć*rta: Greetings: I have programmed the following formula to extract a substring from one column on my worksheet to another: ActiveCell.FormulaR1C1 = "Zone" Range("C2:C" & LastRow).FormulaR1C1 = "=LEFT(RC[-1], SEARCH(""-"", RC[-1])-1)" The problem is that once I have finished extracting my substring, I want to delete the FROM column while still keeping the results of the function in the TO column. If I simply delete the FROM column, I get #REF! errors in all the cells of my TO column. Can anybody point out a simple way around this problem? Is there a simple way to convert the function results to a static value and then remove the FROM column? Regards, Charles |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number appear in text | Excel Discussion (Misc queries) | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Amount or Numbers in Words | New Users to Excel | |||
Threaded Mode
