View Single Post
  #2 (permalink)  
Old September 24th, 2006, 08:19 AM
Shasur Shasur is offline
Friend of Wrox
Points: 3,060, Level: 23
Points: 3,060, Level: 23 Points: 3,060, Level: 23 Points: 3,060, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: , , .
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Iam not sure if I have got your query.

If you want to have a formula referring to the other cell

Sub WroxExcel()
    iRow1 = 2
    iCol1 = 2
    iRow2 = 3
    iCol2 = 3
    Cells(iRow2, iCol2).Formula = "=RC[" & Cells(iRow1, iCol1).Value & "]"

End Sub
Regards
Shasur

http://www.vbadud.blogspot.com
Reply With Quote