Hello Excellers and welcome back for another #Excel #MacroMonday blog post in my Excel 2020 series. This small simple Excel VBA macro will allow you to quickly enable or disable the GetPivotData function in Excel. The GetPivotData Function. The Excel GETPIVOTDATA function can query a Pivot Table and retrieve specific data based on the Pivot Table structure, instead of cell references. Syntax There are three parameters or arguments that are used in GetPivotData. Data_field: … [Read more...]

Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my Excel 2020 Macro series. Today, I will show you how to hide any empty rows in your Excel spreadsheet. Starting The VBA Macro. First, you will need to open the Visual Basic Editor.  There are two ways to do this. Either by hitting ALT +F11 orSelecting the Developer Tab | Code Group | Visual Basic.  Both methods have the same result. Watch The Video On Enabling The Developer … [Read more...]

Hello, Excellers. Time for some more #MacroMonday #Excel fun. I want to share another useful Excel macro today that will convert a range of cells to an image. So, if you need to send an image of some of your Excel workbook to a colleague to put as an image into a presentation, this small bit of code will do all of the hard work for you. Starting The VBA Macro. Before we begin to write any code you need to decide where to store the code. You have a choice. To store your code either in … [Read more...]

Hello, Excellers. Welcome back to more Excel VBA in today's #MacroMonday blog post in my 2020 series. I will show you how to write a really simple Excel macro that will copy the active worksheet to a new Excel workbook. This is really useful if you need to take just one worksheet out of your workbook to create a new workbook. Manually Copy A Worksheet To An New Excel Workbook. If you want to manually carry out the same procedure then feel free to read my corresponding blog post and … [Read more...]