_excel-video-422-looping-to-dynamically-define-a-range.jpg "Excel Video 422 Looping to Dynamically Define a Range 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: 3 min 78 sec
✓ Published: 21-Mar-2015
✓ Published: 21-Mar-2015
Description:
There’s a way to programmatically define a range of cells to work with in Excel Video 422.I’m introducing loops, a way to repeat code a set number of times, in Excel Video 422.I’m also adding a few new functions as well, so I hope this isn’t too much for one video.Hopefully the idea of being able to use code to dynamically define a range makes sense and will be helpful for you in your macros and VBA.nnWatch for the code that tells Excel how many rows to work with in our example.T
There’s a way to programmatically define a range of cells to work with in Excel Video 422.I’m introducing loops, a way to repeat code a set number of times, in Excel Video 422.I’m also adding a few new functions as well, so I hope this isn’t too much for one video.Hopefully the idea of being able to use code to dynamically define a range makes sense and will be helpful for you in your macros and VBA.nnWatch for the code that tells Excel how many rows to work with in our example.T
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_using-slidefab-2-lite-for-automatically-creating-hundreds-of-slides-in-powerpoint-with-dynamic-title-and-chart-based-on.webp "This video shows how easy it is to automatically create a few hundred slides with title and chart automatically using SlideFab 2. With the new SlideFab 2 v1.5 it is possible to automate linked charts which make the setup process even faster. Creating more than 200 slides in this video took in real-time less than 5 minutes. As SlideFab 2 lite edition was used this solutions comes for free.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to em")
⏲ 1 min 46 sec ✓ 17-Oct-2018
_excel-video-439-custom-functions-part-1.webp "Excel Video 439 puts several of the things we’ve learned over the past Excel Videos together to build a custom function in VBA.The custom function is a response to a question a while back in MGMA’s Excel Users group asking for a way to compare the fill color of cells.nnNotice a few things that are different about custom functions.Instead of starting the code like a subroutine with Sub and End Sub, we change to Function and End Function.Our function takes two parameters, the two cells w")
_slidefab-2-writing-an-excel-formula-as-loop-condition-when-automatically-creating-powerpoint-slides.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video explains how a loop condition can be used to leave out loop candidates based on a calculated condition. In this example the modulo operator is used as condition to only create every second slide.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) are required to create PowerPoint")
SlideFab 2. Writing an Excel formula as Loop Condition when automatically creating Powerpoint slides
⏲ 1 min 5 sec ✓ 07-Mar-2018
_slidefab-2-how-to-create-one-output-file-per-loop-candidate-when-automating-powerpoint-slides.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video shows how SlideFab can decompose the output presentation into separate files, 1 presentation file per loop.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) are required to create PowerPoint presentations automatically. This is not the case with SlideFab 2. With decent Excel ski")
⏲ 1 min 4 sec ✓ 07-Mar-2018
_peter-bryant-json-services-natively-access-vba-preview.webp "Access can talk to HTTP services, but doesn't provide built-in abilities to deal with the data from JSON or XML API calls. Whilst there are third party tools and libraries out there, they have their limitations and might not be permitted or welcome on a project (which is how this came about). We show how to do it in Access VBA with a few standard references and no other external dependencies.nn•An introduction to JSON and API web services that use itn•Why do it internally in Access, and")
_excel-vba-beginner-tutorial-series-2-record-a-vba-macro-vba-cell-reference-copy-paste-in-vba.webp "In this second video of the Excel VBA Beginner Tutorial Series, we will cover four main topics in VBA :nn1) Recording a simple basic macron2) How to save the recorded macro filen3) How to use VBA cell referencingn4) How to copy-paste data in VBAnnI would like to recommend you watch my entire Excel VBA Beginner Tutorial Series from Beginning for better understandingnnRecord a macro:nRecording a macro will record all the actions you do on this sheet. If you try to make it Bold, Italic, Underline,")
Excel VBA Beginner Tutorial (Series 2) - Record a VBA Macro - VBA Cell Reference - Copy Paste in VBA
⏲ 12 min 17 sec ✓ 03-Sep-2020
_human-vs-machine-competition-who-can-create-powerpoint-slides-based-on-excel-data-faster.webp "In this video Alice competes against Bob. Alice uses SlideFab 2 whereas Bob uses his brute force and copy_paste skill. The task is to create 100 dashboard slides in PowerPoint based on an Excel model containing the calculation.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) are required to create PowerPoint presentations automatically. This is not the case with SlideFab 2")
⏲ 1 min 50 sec ✓ 18-Dec-2018
_slidefab-2-installation.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video shows how SlideFab can be installed.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) are required to create PowerPoint presentations automatically. This is not the case with SlideFab 2. With decent Excel skills everybody can create hundreds of presentations or slides automatica")
_using-slidefab-2-lite-for-automatically-creating-hundreds-of-slides-in-powerpoint-with-dynamic-title-and-chart-based-on.jpg)
_excel-video-439-custom-functions-part-1.jpg)
_slidefab-2-writing-an-excel-formula-as-loop-condition-when-automatically-creating-powerpoint-slides.jpg)
_slidefab-2-how-to-create-one-output-file-per-loop-candidate-when-automating-powerpoint-slides.jpg)
_peter-bryant-json-services-natively-access-vba-preview.jpg)
_excel-vba-beginner-tutorial-series-2-record-a-vba-macro-vba-cell-reference-copy-paste-in-vba.jpg)
_human-vs-machine-competition-who-can-create-powerpoint-slides-based-on-excel-data-faster.jpg)
_slidefab-2-installation.jpg)
![[+]](/images/menu.gif){kind=small}