View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cantonarv cantonarv is offline
external usenet poster
 
Posts: 1
Default Range - setting a value in a cell

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