| Using the range property it is easy to apply formatting on cells in an excel worksheet because the VBA editor pops up a menu whenever you place a '.' after defining the cell. Only if you make a mistake the menu does not pop up. Now you can be sure that you have made some mistake in the definition of your range property! You can apply all kinds of formatting on your data like bold, italic, color, background color, etc. |