Tag: Excel VBA

Excel TutorialExcel VBA TutorialTutorial

Copying/Moving Rows and Columns with Excel VBA

Copy a single row

Move a single row

Move multiple rows

Move a single column

Move multiple columns

Move a row to another worksheet

Move a row to the end of the table

Read More
Excel TutorialExcel VBA TutorialTutorial

Excel VBA File Management Using The FileSytemObject

Using the FileSytemObject The FileSystemObject (FSO) provides a useful way to access the filing system on your computer and network drives.  To use the FSO you first need to create a reference to the Microsoft Scripting Runtime Library.

In the VBE click Tools | References. Check the option Microsoft Scripting Runtime and…

Read More