_excel-video-405-more-tricks-to-help-the-macro-recorder.jpg "Excel Video 405 More Tricks to Help the Macro Recorder from vba the code in this project must be updated Video Screenshot Preview")
GalleryPlay Video:
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 4 min 25 sec
✓ Published: 21-Mar-2015
✓ Published: 21-Mar-2015
Description:
Watch three tricks to help the Macro Recorder do a better job in Excel Video 405.The first trick is to switch between the absolute and relative references we discussed in Excel Video 404.Watch how I start with an absolute reference to cell A1 so that no matter where I am in the spreadsheet, my macro starts at cell A1.Once we’re there, I switch to relative references so that the second trick will work.nnTrick number two is to use arrow keys in combination with keys like End, Shift and Ctr
Watch three tricks to help the Macro Recorder do a better job in Excel Video 405.The first trick is to switch between the absolute and relative references we discussed in Excel Video 404.Watch how I start with an absolute reference to cell A1 so that no matter where I am in the spreadsheet, my macro starts at cell A1.Once we’re there, I switch to relative references so that the second trick will work.nnTrick number two is to use arrow keys in combination with keys like End, Shift and Ctr
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_redteam-asr-bypass-and-amsi-bypass-for-excel-macro-dll-dropper.webp "This video shows how to embed a dll in an Excel document with MacroPack Pro. In this case the payload is ReactOS")
_automatically-creating-slides-with-powerpoint-charts-based-on-an-excel-workbook-with-slidefab-2.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video demonstrates how to automatically create slides in Powerpoint using SlideFab. Each slide will contain a Powerpoint chart which and SlideFab will update the data range for each of these charts automatically. The first part of the video shows how to create an empty Powerpoint slide with an empty Powerpoint chart on it as template. In the second part the video explains how an Excel model can be built wh")
⏲ 2 min 12 sec ✓ 16-Mar-2018
_redteam-excel-4-0-xlm-shellcode-using-macropack-pro.webp "This video shows how to trojan an Excel sheet with a malicious XLM macro injecting a meterpreter shellcode. nThis video was uploaded in the context of a blog post concerning addition of XLM payloads to MacroPack Pro (https://blog.sevagas.com/?EXCEL-4-0-XLM-macro-in-MacroPack-Pro)nnIn the video I first open the file, then I open it again after it is trojaned with XLM macro.nnHere is the command line used to generate the payload: necho meterx86_no0.bin | macro_pack.exe -t SHELLCODE -o --xlm --stea")
_how-to-record-a-macro-using-microsoft-word-part-3.webp "Welcome to Part 3 of my tutorial on Recording A Macro Using Microsoft Word. If you would prefer a Hi-Resolution version of this video one can be downloaded from my website with a printable guide. kingsolutions.org.uknIn this tutorial you'll learn how to make changes to your macro using the Visual Basic for Applications (VBA) Editor.nIn Part One you learned how to use the Macro Recorder to turn your keystrokes and mouse movements into a macro code. You also learned how to run the macro using the")
_slidefab-2-how-to-create-a-basic-92.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video demonstrates how to set up a simple Hello World workbook and presentation with SlideFab 2. It contains the most simple case where a formula-based text from Excel is multiple times written to a shape in a Powerpoint presentation.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to empower Excel users. Typically coding skills in VBA (Visual Basic) a")
_automatically-creating-powerpoint-presentation-category-trees-from-excel-with-slidefab-2.webp "This SlideFab 2 video shows how to create category trees automatically. It features various advanced SlideFab 2 features such as slide loops, sort order and VBA code calls. This example visualizes category spend and puts each category on one or more tree slides where the branches resemble sub category spend. For each sub category the top 3 suppliers and top 3 countries by spend are shown. The Powerpoint to Excel automation then creates the slides automatically within minutes. This helps to speed")
⏲ 1 min 80 sec ✓ 24-Jul-2018
_fractal-energy-storage-model-v-21-12-updates.webp "View the latest updates and new features of version 21.12 Fractal Model (released December 2021). The Fractal Model™ is a powerful technoeconomic energy storage and hybrid system modeling tool that provides investment grade analysis while simulating performance, degradation, warranty, costs and revenue to optimize the economics of your project. This tool is an excel package interface with an additional JavaScript calculation engine through a Microsoft 365 Add-In. nnThe tool is intended for pro")
_excel-video-410-watching-the-macro-recorded-work-in-vba.webp "Excel Video 410 gives you a behind the scenes look at what the Macro Recorder is doing in Visual Basic for Applications when it records a macro.Watch how I use Alt+F11 to open the Visual Basic Editor and follow along as I record a macro in Excel.If you want to learn how to write code in VBA, this is a great way to do it.You can always look up how to write specific code and it may help to read the help file to understand specific options for an Excel feature, but watching the Macro Recorder")
_redteam-asr-bypass-and-amsi-bypass-for-excel-macro-dll-dropper.jpg)
_automatically-creating-slides-with-powerpoint-charts-based-on-an-excel-workbook-with-slidefab-2.jpg)
_redteam-excel-4-0-xlm-shellcode-using-macropack-pro.jpg)
_how-to-record-a-macro-using-microsoft-word-part-3.jpg)
_slidefab-2-how-to-create-a-basic-92.jpg)
_automatically-creating-powerpoint-presentation-category-trees-from-excel-with-slidefab-2.jpg)
_fractal-energy-storage-model-v-21-12-updates.jpg)
_excel-video-410-watching-the-macro-recorded-work-in-vba.jpg)
![[+]](/images/menu.gif){kind=small}