Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub UniqueFindColumn()
Dim AnArray() As String, i As Long Dim Selec As Range Dim Desti As Range Set Selec = Application.InputBox( _ Prompt:="Select cell for Actual data.", Type:=8) Set Desti = Application.InputBox( _ Prompt:="Select cell for Actual data.", Type:=8) AnArray = GetUniqueEntries(Selec) If Len(AnArray(0)) 0 Then For i = 0 To UBound(AnArray) Range(Desti).Offset(i, 0) = AnArray(i) Next End If End Sub What wrong in the above macro with respect to my output i.e Desti range. Thxs Actual I tried to amend the macro below: Sub UniqueFind() Dim AnArray() As String, i As Long AnArray = GetUniqueEntries(Range("A1:D12")) If Len(AnArray(0)) 0 Then For i = 0 To UBound(AnArray) Range("F1").Offset(i, 0) = AnArray(i) Next End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forumla that Looks up a range of output from one cell | Excel Worksheet Functions | |||
List Box - For Input Range can I use named range in another workbo | Excel Worksheet Functions | |||
Print output does not contain entire range | Excel Discussion (Misc queries) | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Macro to input formula in range based on another range | Excel Programming |