So I decided to record a macro, and for some reason, I forgot to hit Stop Recording. By the time I realized I was still recording, I had created a macro that represented a half a day’s work.
Don’t laugh…you’ve done this too.
If you’re not certain if you’re in Macro Record mode or not, you can simply look at the bottom left corner of your screen.
Excel 2003 will show the word “Recording”. Excel 2007/2010 will show a Stop icon (clicking the stop icon is a handy way to stop recording).
Bonus Career Tip: If you have one of those managers who want an email outlining what you accomplished each day, just record a macro all day, then send him the code.
RELATED STUFF
Sub Macro2()
'
' Macro2 Macro
'
'
Application.Speech.SpeakCellOnEnter = True
Range("C5").Select
ActiveCell.FormulaR1C1 = _
"Take this job and shove it, I don't work here anymore"
Range("C6").Select
End Sub
@Jeff….
I tried to get that to work, but it doesn’t speak the text. But an Innovative message that gets the point across. When I do decide to pull the trigger, this is how I am going to do it, then use the kill method to delete every file on their hard drive.
I’ll have to remember that for my next performance review!