Almost there,

Cells is a range, so just use

Cells(1,1) for a single cell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"waveracerr " wrote in message
...
Dim Rng as Range
Dim strName As Object
Set strName = Worksheets("12 15 03 07 KWSC1_1a").Range("O2")

How can I assign a variable to the range, rather than having the "02"
cell reference? I've seen the following:

Dim Rng as Range
Dim myRange As Object
Set myRange = Worksheets("Sheet1").Range(Cells(1,1).Cells(10,5))

..as a way to use Cells and thus vary the column & row.

How can I set the range to something like:
Range(Cells(1,1))?

Thanks


---
Message posted from http://www.ExcelForum.com/