Blog ~ Site Name

Excel Video 432 Message Boxes Part 1

posted by Nate Moore on October 20th, 2014 at 7:11 PM

0 Comments added to this post

 Here’s the first of three videos on Message Boxes in Excel.

Read More ...

Excel Video 431 Looping Example

posted by Nate Moore on October 13th, 2014 at 7:37 PM

0 Comments added to this post

One final video about looping…

Read More ...

Excel Video 430 Do Until Loops

posted by Nate Moore on October 6th, 2014 at 8:08 PM

0 Comments added to this post

 If you watched Excel Video 429, this video will make a lot of sense as another way to loop.

Read More ...

Excel Video 429 Do While Loops

posted by Nate Moore on September 29th, 2014 at 5:38 PM

0 Comments added to this post

 Here’s another way to loop through data with VBA.

Read More ...

Excel Video 428 Looping Through Workbook Objects

posted by Nate Moore on September 22nd, 2014 at 7:28 PM

0 Comments added to this post

 We’ve spent several Excel Videos looping through rows and columns in a worksheet.  Here’s a way to loop through Excel objects in your workbook.

Read More ...

Excel Video 427 Exiting Loops

posted by Nate Moore on September 15th, 2014 at 9:06 PM

0 Comments added to this post

 If you find a problem as you’re looping through data, here’s how to stop the loop so you can fix the problem.

Read More ...

Excel Video 426 Nesting Loops

posted by Nate Moore on September 8th, 2014 at 6:16 PM

0 Comments added to this post

 Here’s how to make a loop inside another a loop…

Read More ...

New Article on Paste Special

posted by Nate Moore on September 3rd, 2014 at 7:19 PM

0 Comments added to this post

Now that you're familiar with cutting, copying, and pasting data, I've posted a new article on Paste Special.

Read More ...

Excel Video 425 Looping to the End of the Data

posted by Nate Moore on September 1st, 2014 at 6:25 PM

0 Comments added to this post

 Here’s one line of code that makes your macros much easier to run as the size of your data changes.

Read More ...

Excel Video 424 Loops with Steps

posted by Nate Moore on August 25th, 2014 at 6:38 PM

0 Comments added to this post

 Here’s how to make your loop shade alternate rows.

Read More ...

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 ...

More entries...

Better Data Better Decisions

Get Your Data

Invite Nate to Speak

Facebook
Twitter
Subscribe to my blog
LinkedIn