Find actual location of Cell in Range 1

[jessedh]

Hi Everyone (again)

This time I have to find the absolute location in pixars of cell L2 in a set of sheets

The reason why is that I have to paste a form into each sheet and if I don't know its absolute location everything gets messed up.

I am not even sure that this can be done so any help is much appreciated!

Thanks
Jesse

 

[Zathras]

The .Top and .Left properties of a Range object provide the placement coordinates relative to the top left corner of the sheet area. This may or may not be good enough for your purpose:

Sub Test()
  MsgBox "Top=" & [L2].Top & "   Left=" & [L2].Left
End Sub

 

[jessedh]

That is exactly what i needed!!