Referencing a sheet with a variable of type string in a macro

[asunwatcher]

I'm writing a function that gets data from a worksheet with a name dependant of the value of a cell. The cells value (e.g. Sheet1) is called into the function as string_name.

Essentially I want to transform this code

xrange = Sheets("Sheet1").Range("I2:I20").Value

into something like this

xrange = Sheets(string_name).Range("I2:I20").Value

I realise it's probably a silly question, but I've been unsuccessful in implementing this for a few hours now...help would be greatly appreciated.

 

[mikerickson]

Dim string_name as string, xrange as variant
string_name = "Sheet1"

xrange = Sheets(string_name).Range("I2:I20").Value

will do the same as

Dim xrange as Variant

xrange = Sheets("Sheet1").Range("I2:I20").Value

 

[asunwatcher]

you know the problem was I wasnt saying string_name as string. talk about wasted time! Thanks for the help @mikerickson - it was indeed a silly question