maybe this will help:

Dim ShtName as String
ShtName = "Sheet" & str(n)

reference it like this:
ThisWorkbook.Worksheets(ShtName)

Hope this helps
-Steve


"ibbm" wrote:

> I have 3 worksheets that I fill with Data depending if the country is US,
> Canada or Not Defined. What I want to do is reference the worksheet with a
> variable such as
>
> if country = US then n = 1
> else if country = Canada then n = 2
> else n = 3
> endif
>
> This worksheet(n) = the data
>
> I don't know if this can be done. I get an error when I try it. If I can
> do this then I don't have to write a section for each of the different
> worksheets.
>
> Thanks In advance
>