Referencing other sheet using column numbers

[Dons1000]

I'm writing a macro in Excel to move some data into another worksheet. How do you set a reference in excel to a different worksheet and use numbers instead of letters

I don't want to use =sheet1!C3 but something like
=sheet1!(3,3)

 

[SkipVought]

Hi,

Do you want to enter FORMULAS in the cell or VALUES?

For FORMULAS...

  Sheet2.Cells(1,1).Formula = "=sheet1!R3C3"

for VALUES...

  Sheet2.Cells(1,1).value = sheet1.cells(3,3).value

Skip,
[sub]
[red][/red]
[/sub]

 

[Dons1000]

Formulas but not using the R3C3 reference instead using numbers.

 

[SkipVought]

A1 notation or R1C1 notation in formulas as your only choices in formulas.

You could do...

with sheet1.cells(3,3)
  Sheet2.Cells(1,1).formula = "=" & .parent.name & "!" & .address(false, false)
end with

Skip,
[sub]
[red][/red]
[/sub]