Setting string in Excel

[krets]

What I would like to do is set a variable based on a cell value in Excel. I've never done this before and can't seem to find a good reference.

Like:

Sub MySub()
Dim mVar as String

If ActiveSheet.Range("A1") = "Cell 200" Then
 mVar = I want to set the variable to something like "Week1!A3:A11"
End If

End Sub

 

[SkipVought]

Hi,

 mVar = Sheets("Week1).Range("A3:A11").Value

If you have the row limits in variables...

 mVar = Sheets("Week1).Range(Sheets("Week1).Cells(RowStrt, "A"), Sheets("Week1).Cells(RowEnd, "A")).Value

Skip,

_[red][/red]