Excel TutorialTutorial

Excel’s #NUM! Error – What Does it Mean?

Have you ever wondered what Excel's #NUM! error actually means? The #NUM! error can appear for several reasons:  here are three of the most likely.

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE! 

Reason 1: You are Performing an Impossible Calculation in Excel If you perform an impossible calculation in Excel you will get the #NUM! error. An example of…

Read More
Excel TutorialExcel VBA TutorialTutorial

Copying/Moving Rows and Columns with Excel VBA

Copy a single row 'Copy row 3 to row 13 Sub CopyRow() Rows(3).Copy Rows(13).Insert End Sub

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE! 

Move a single row 'Move row 3 to row 5 Sub MoveRow() Rows(3).Cut Rows(6).Insert End Sub Move multiple rows 'Move rows 7-9 to row 3-5 Sub MoveMultipleRows() Rows("7:9").Cut Rows(3).Insert End Sub Move a single column [contentblock…

Read More