referencing a particular cell

[sanjna000]

Hi,

I need to reference a particular cell in a different worksheet. I used following code but it doesn't seem to be working.

ActiveSheet.Cells(invTotal_rno, invTotal_cno).Select
ActiveCell.FormulaR1C1 = "=Sheets(1)!N24"

What i want here is, i need to copy the same value in Sheets(1)! N24 to the current sheet Cells(invTotal_rno, invTotal_cno).

Can anyone help me with that?

Thanks a lot for u r help in advance.
Sanjna...

 

[KenWright]

Just the value

ActiveSheet.Cells(invTotal_rno, invTotal_cno).Value = Sheets("Sheet2").Range("N24").Value

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------