SPreadsheets formatting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mars (anonymous_at_discussions.microsoft.com)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 02:49:42 -0700

Is there a way programmatically correct Excel spreadsheets
formatting? I have an Excel Workbook which contains many
spreadsheets invoices, that have the same form and same
formulas. Problem is thatt some of spreadsheets invoices
are created a little inaccuratly, i.e. some cells with
value and formulas are displaced relatively the previous
spreadsheet cells. Example: some spreadsheets have q-
ty, sum, total located in other cell relatively the
previous spread***. Does it possible 'normalize'
formatting of all spreadsheets without alteration of each
*** separately? For example, set some *** as a sample
and automatically format all others spreadsheets the same
way? (withous loss anu data)

Quantcast