Learn Excel – “Address of Previous Cell” – Podcast #1743

July 5, 2013 at 5:08 pm

Ams asks if there is some VBA that will tell you the previously selected cell. Consider this: you are in A1, then click in B1; Is there any VBA that will tell you that the previous cell was A1? And it seems like this should be possible. In today’s Episode #1743, see how Bill puzzles out the solution by using the Macro Recorder to learn about Names then VBA AutoComplete to find the right property. Near the end of the video, Bill adds two new names to show that the value of A1 was “X” when you selected it, but “Z” when you left it.

"Excel 2013 InDepth" - by Bill Jelen

Microsoft 2013 InDepth” – by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013.

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!


Entry filed under: Uncategorized.

Learn Excel – “Risk Factor / 3 Way Lookup” – Podcast #1742 Learn Excel – “Excel on iPhone Review” – Podcast #1744

Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 742 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive

%d bloggers like this: