Sorting unique values and returning values from a formula
 

I have a macro to sort unique values from one worksheet to the next. My
macro retruns the formula from the range of cells vs. the values which I
need. What would I need to change in the macro below to list the unique
values instead of the formulas?

Sub unique()
'
' unique Macro
' Macro recorded 2/17/2006 by andersma
'

'
Sheets("Conversion").Range("G1:G3000").AdvancedFil ter
Action:=xlFilterCopy, _
CopyToRange:=Range("C1"), unique:=True
End Sub

Sorting unique values and returning values from a formula
 

Marcus,
Try it after adding a column title/heading in G1.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"MarcusA" wrote in message...
I have a macro to sort unique values from one worksheet to the next. My
macro retruns the formula from the range of cells vs. the values which I
need. What would I need to change in the macro below to list the unique
values instead of the formulas?

Sub unique()
' unique Macro
' Macro recorded 2/17/2006 by andersma'
Sheets("Conversion").Range("G1:G3000").AdvancedFil ter
Action:=xlFilterCopy, CopyToRange:=Range("C1"), unique:=True
End Sub

Sorting unique values and returning values from a formula
 

Thank you!!! it worked.

"Jim Cone" wrote:

Marcus,
Try it after adding a column title/heading in G1.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"MarcusA" wrote in message...
I have a macro to sort unique values from one worksheet to the next. My
macro retruns the formula from the range of cells vs. the values which I
need. What would I need to change in the macro below to list the unique
values instead of the formulas?

Sub unique()
' unique Macro
' Macro recorded 2/17/2006 by andersma'
Sheets("Conversion").Range("G1:G3000").AdvancedFil ter
Action:=xlFilterCopy, CopyToRange:=Range("C1"), unique:=True
End Sub