New to Excel VBA

P

pkohler

I am relatively new to writing macro's in Excel.

I am writing a macro to search a given range and return only the uniqu
fields. The problem that I am having is that I would like to have th
user select the range. Is there a method or a function that I can cal
that utilises the range selector that is in the formula wizard?

Thanks
 
K

kkknie

A bit of plagerizing from John Walkenbach's book (Excel 2002 Powe
Programming with VBA):

Code
-------------------
Sub Test()
Dim UserRange as Range
DefaultRange = Selection.Address
On Error Goto Cancelled
Set UserRange = Application.InputBox _
(Prompt:="Range to Search:", Title:="Range Search", _
Default:=DefaultRange, Type:=8)
'Add your search using UserRange as the range variable.
Cancelled:
End Su
-------------------

K

P.S. The key is to use the Application.Inputbox rather than jus
InputBox since it gives you the Type option. Type 8 is a range.
 
Top