Excel Excel Macro - Set Range to Text in Cell

[roxy26girl]

Hi,
I'm relatively new to VBA, so excuse me if this is a dumb question. I have a workbook with a tab that users enter different variables into. One cell is meant to input a range that later on will be used to perform selections on other tabs. I can't seem to set my range to the text in the input cell. An abbreviated form of the macro I'm trying to use is this:

Sub Macro1()
Dim RetrieveRange As range

Set RetrieveRange = range(Worksheets("Admin").range("B1").Text)

MsgBox RetrieveRange.Address

End Sub

I keep getting this error: "Run-time error '1004': Method 'Range' of object '_Global' failed"

Can anyone help?

Thanks!

 

[Stoneboysteve]

I pasted your code as a macro, created an Admin tab, and entered a valid range (A1:A2) and it worked for me. I entered an invalid range ('before') and got the error.