View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
 
Posts: 238
Default What am I doing wrong

Sub error()
Dim RowNumber As Double
Dim SecondDig As Double
RowNumber = Range("E386").Value 'Read RowNumber #
RowNumber = RowNumber - 4096 'Shift the RowNumber value
Range("H386").Value = RowNumber 'Print to make sure it worked
SecondDig = Range(RowNumber, 3).Value ' I get an error here
' using RowNumber as the row value
Range("I386").Value = SecondDig
End Sub

I get an error message on line 7. I am using a variable as the roe
number. What am I doing wrong?