I currently have a sheet that I need to format many columns. The columns are not always next to each other. Is it possible to accomplish without adding the style one column at a time? I was thinking of something like CreateRange("L:L,P:P,R:R,AA:AA") to create this range then I would apply the style for these four columns. Also I noticed a RangeCollection class, do I need to use that? I looked at the examples but I could not find a way to utilize the RangeCollection class to get this done.