Consider the following:
It is a known fact that Excel 2007 has up to 16384 rows per sheet and that one does not want to format cells that are completely unused. Is there a way, using VBA code, to limit Excel to only use, say, 20 columns?![]()
If a <> b then Range("somerange").EntireRow.Font.Strikethrough = True end if
Bookmarks