Copy from Formula Bar

[Sahak]

Hi all,

Sometimes copying from the cell (passwords or links), after pasting does not work.
Is there a macro to copy Formula Bar's contents?
Thank you in advance.

 

[Yongle]

Sometimes copying from the cell (passwords or links), after pasting does not work

why does it not work?
why would copying from the formula bar return a different result?

 

[Sahak]

Hi Yongle,

Thank you for your reply. Why I don't know
Is there a macro?

 

[Yongle]

Which macro are you using now to copy from the cell?

 

[Sahak]

Hi Yongle,

Now I know why, the cell copying from, was in a hidden column. But anyway, to learn something new, is there a macro?

 

[Yongle]

Which macro are you using to copy from the cell?

 

[Sahak]

Sub Copy_Link()
    If ActiveCell.Column = Range("Clmn_Payee").Column And ActiveCell.Offset(0, 1) = "Y" Then
        ActiveCell.Offset(0, 2).Copy
        MsgBox "Please Paste the Copied Link"
    Else
        MsgBox "Wrong Selection, Please Select Payee"
    End If
End Sub

 

[Yongle]

how about

ActiveCell.Offset(0, 2).Formula.Copy

 

[Sahak]

It gives an error:

 

[Yongle]

Oops !