If you’d like to use a macro in one spreadsheet to change another spreadsheet, watch Excel Video 419. Today we’ll review the syntax to reference another workbook from VBA. The first thing you’ll notice is that the second workbook has to be open for the VBA code to work.
I’ll also introduce the With…End With syntax. It’s a great way to reference a cell or a range of cells once and then do several things without having to type in the reference each time.
Finally, I’ll show you how to change the font color in a cell. If you aren’t familiar with the RGB way of referencing colors, there are several color pickers on the internet that can help you get just the color you’re looking for.
