When you try to iterate over an empty array in VBA like this, you will get a runtime error (index out of bounds): Sub ArrayTest() Dim testarray() As Integer Dim i As Integer For i = LBound(testarray) To UBound(testarray) ‘ <– error Debug.Print testarray(i) Next i End Sub Even if…
When creating presentations the Presentation Zen way, you end up using lots and lots of pictures. If you use pictures that are published under a Creative Commons license you may need to mention the names of the original authors/photographers. I do so by showing a slide show with all pictures…
Just a little snippet to resize and rotate all images in a Word 2010 document. I needed it to create a table with multiple images per row/column from some dragged and dropped images. Option Explicit Sub ResizeAndRotateAllImages() Const ROTATION = 90 Const HEIGHT = 7 Dim n As Integer For…