Referencing to a cell

[becklog]

Hi,

I have the formula below. How do I reference selection.name to a cell. Thanks!

Sub Shoot()
Dim r As Range
Window_Capture_VBA
Selection.Name = ActiveCell
ExportPicture ActiveCell
End Sub

 

[Rick Rothstein]

I have the formula below. How do I reference selection.name to a cell. Thanks!

Sub Shoot()
Dim r As Range
Window_Capture_VBA
Selection.Name = ActiveCell
ExportPicture ActiveCell
End Sub

What you are showing is VB code, not a formula. I am unclear what you are asking for when you say "reference selection.name to a cell". Do you mean that you want to place the name you just gave your selection into a cell? If so, why not just assign the value in the ActiveCell (which you used to name the selection) directly to this other cell?