Blog ~ Site Name

Excel Video 423 Introducing Loops

posted by Nate Moore on August 18th, 2014 at 4:42 PM

0 Comments added to this post

 We’ll start discussing loops in Excel Video 423.

Read More ...

Excel Video 422 Looping to Dynamically Define a Range

posted by Nate Moore on August 11th, 2014 at 4:37 PM

0 Comments added to this post

 Here’s a way to programmatically define a range of cells to work with.

Read More ...

New Article on Cutting, Copying, and Pasting Data

posted by Nate Moore on August 6th, 2014 at 4:07 PM

0 Comments added to this post

 Here's a link to a free article on cutting, copying, and pasting data.

Read More ...

Excel Video 421 Referencing Tables in VBA

posted by Nate Moore on August 4th, 2014 at 7:14 PM

0 Comments added to this post

 Tables are a great way to manage Excel data.  Here’s how to reference a Table using VBA.

Read More ...

Excel Video 420 VBA Editing Shortcuts and Selecting the Current Region

posted by Nate Moore on July 28th, 2014 at 6:42 PM

0 Comments added to this post

 A couple of very useful shortcuts today…

Read More ...

Excel Video 419 Using a Macro to Change Another Workbook

posted by Nate Moore on July 21st, 2014 at 9:12 PM

0 Comments added to this post

 Here’s how to use a macro in Workbook A to change Workbook B.

Read More ...

Excel Video 418 More Ways to Identify Ranges

posted by Nate Moore on July 14th, 2014 at 4:37 PM

0 Comments added to this post

 Watch how to identify ranges on another worksheet in the same workbook.

Read More ...

Excel Video 417 Identifying Ranges

posted by Nate Moore on July 7th, 2014 at 8:12 PM

0 Comments added to this post

 Here’s how to identify which cells we want to work on.

Read More ...

Excel Video 416 Debugging with the Watch Window

posted by Nate Moore on June 30th, 2014 at 8:13 PM

0 Comments added to this post

 Here’s another way to keep track of values in your code and see when they change.

Read More ...

Excel Video 415 Debugging with the Immediate Window

posted by Nate Moore on June 23rd, 2014 at 5:48 PM

0 Comments added to this post

 Here’s one way to keep track of how locations and values in your spreadsheet change as your code runs.

Read More ...

Excel Video 414 Debugging by Controlling Which Line of Code Runs Next

posted by Nate Moore on June 16th, 2014 at 5:46 PM

0 Comments added to this post

 Here are 3 ways to change which line of code runs next in your Macro.

Read More ...

Excel Video 413 Debugging with Step Over and Step Out

posted by Nate Moore on June 9th, 2014 at 4:56 PM

0 Comments added to this post

 Two more tricks to add to your debugging arsenal…

Read More ...

Excel Video 412 Debugging with Breakpoints

posted by Nate Moore on June 2nd, 2014 at 7:35 PM

0 Comments added to this post

 Breakpoints make your code stop running where you need to analyze your code.

Read More ...

Excel Video 411 Debugging with Step Into

posted by Nate Moore on May 26th, 2014 at 7:17 PM

0 Comments added to this post

 Here’s the first VBA debugging tool.

Read More ...

Free Article on Removing Duplicates in Excel

posted by Nate Moore on May 21st, 2014 at 9:12 PM

0 Comments added to this post

 The Remove Duplicates feature in Excel can save you a boatload of time.  Here's how to use it.

Read More ...

Excel Video 410 Watching the Macro Recorder Work in VBA

posted by Nate Moore on May 19th, 2014 at 8:50 PM

0 Comments added to this post

 Here’s a behind the scenes look at what the Macro Recorder is doing in VBA when it records a macro.

Read More ...

Excel Video 409 Adding Macros to Shapes and Pictures

posted by Nate Moore on May 12th, 2014 at 4:59 PM

0 Comments added to this post

 Here’s a more creative way to launch macros

Read More ...

Excel Video 408 Creating a Button to Run a Macro

posted by Nate Moore on May 5th, 2014 at 3:38 PM

0 Comments added to this post

 Here’s another way to make a macro run on your spreadsheet.

Read More ...

Excel Video 407 Adding Macros to the Toolbar and Ribbon

posted by Nate Moore on April 28th, 2014 at 8:04 PM

0 Comments added to this post

 Here are some ways to make your macros easier to run.

Read More ...

Excel Video 406 VBA Code Created by the Macro Recorder

posted by Nate Moore on April 21st, 2014 at 8:07 PM

0 Comments added to this post

 Here’s a brief introduction to VBA.

Read More ...

More entries...

Better Data Better Decisions

Get Your Data

Invite Nate to Speak

Facebook
Twitter
Subscribe to my blog
LinkedIn