simple range problem
 

what am i doing wrong

dim myRange as Range
dim iNum as integer
iNum= 6

Set myRange = Cells(iNum + 2, 1)
myRange.Value = 34

trying to set a cell myRange to cell(8,1)
then putting the value 34 into the cell

simple range problem
 

I just tested with xl2002 and it worked fine but why not just
cells(inum+2,1)=34
or
cells(8,1)=34

--
Don Guillett
SalesAid Software

"cantonarv" wrote in message
oups.com...
what am i doing wrong

dim myRange as Range
dim iNum as integer
iNum= 6

Set myRange = Cells(iNum + 2, 1)
myRange.Value = 34

trying to set a cell myRange to cell(8,1)
then putting the value 34 into the cell