Why isn the File Print Preview command available in a VBA module?
The Excel designers apparently thought this command was not necessary because you can’t really do any formatting on a VBA module sheet. If you really must preview a VBA module, copy the code to a worksheet and use the worksheet’s print preview feature. I’m having trouble with the concatenation operator (&) in VBA. When I try to concatenate two strings, I get an error message. This is probably because VBA is interpreting the ampersand as a type declaration character. Make sure you insert a space before and after the concatenation operator.
