I am confused about how to specify my range given the
following variables

FirstWeek is an integer variable
LastWeek is an integer variable
myRow is an integer variable
Blank1Range is a range

I want to set Blank1Range to include cells from the
column # from FirstWeek to column# from LastWeek, all on
row # from myRow.

I would know how to do this if I was able to determine
the column letter of a given cell, but I don't know how
to get this. Can anyone help me write the SET statement
with this information?

Set Blank1Range = Worksheets("Blank 1").Range("?" & myRow
& ":?" & myRow & "")

Thanks,
Mike.