Copying to clip board

[eddysmithjr]

Good morning fellow Excellers!!

If there any function, formula, or macro I can assign to a button in Excel that will copy the contents (especially the result of a formula) to the "clipboard" so it can be pasted in another window, program, etc etc?

Example

A:1 will read "Sent Message to Customer" if B1=Y, I have already set up the formula for A:1, so now, when A:1 does equal "Sent Message to Customer," I want an easy way for my client to have that copied to their clipboard so all they have to do is paste it somewhere else.


Any help is once again greatly appreciated!

 

[eddysmithjr]

Thanks for the help!

Last question, I have a macro for another work book, and I want to know how I can adapt it for this book.

Basically, if a cell in column E equals "0" (which I set up as the other function of my IF formula) I want the row that the cell is on to disappear.

The Macro I have is:

Sub foo()
Dim c As Range
Cells.EntireRow.Hidden = False
For Each c In Range([A1], Cells(Rows.Count, "A").End(xlUp))
If c.Value = 0 Then c.EntireRow.Hidden = True
Next c
End Sub


Can anyone show me how to adapt it for this Workbook?

 

[VoG]

Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Calculate()
Dim LR As Long, i As Long
LR = Range("E" & Rows.Count).End(xlUp).Row
For i = 1 To LR
    Rows(i).Hidden = Range("E" & i),Value=1
Next i
End Sub

 

[eddysmithjr]

It's saying syntax error, and the first line (Private Sub Worksheet_Calculate()) is highlighted in yellow?

 

[eddysmithjr]

Edited:

It's still highlighting, I thought it stopped, but it didn't :-/

 

[eddysmithjr]

Actually, I got everything to work!

Thanks to both of you for all of the assistance!