| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display a formula as a value using a macro
I have a macro which allows me to display unique data on a seperate worksheet. How can I get the concatenate formula to display as text on my new worksheet? Below is the macro I used to sort unique values. Sub uniquevalue() Sheets("Conversion").Range("G2:G3000").AdvancedFil ter Action:=xlFilterCopy, _ CopyToRange:=Range("C2"), Unique:=True End Sub Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Macro to edit formula | Excel Discussion (Misc queries) | |||
| moving the formula "average" over one column in a macro | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Can you enter a formula in a cell to run a macro? | Excel Worksheet Functions | |||
Hybrid Mode
