I need to cater for 3 different levels of Value Added Tax (VAT).
I'm wondering whether cycling through each sheet, calculating as
I go, or whether building 3 arrays and then calculating, would
prove more efficient?

The user would first 'tag' each applicable item with the value A,
B or C, in the same row, but in column Z. The user would only do
this once for each workbook.

The code would then sample down column S along the lines of:

For Each c In UsedRange.Columns(19) ....S
If Not IsEmpty(c) Then
If IsNumeric(c.Value) Then
If c.Value "0" Or c.Value "0.00" Then
'multiply c by either A B or C found in col Z, same row, and put the
'value in col T, same row.

I want the routine to be flexible so I won't hardcode the values
for A, B or C. Rather I'm thinking to start the routine by building
a Collection of the values in col Z, and then presenting a form
for the user to enter their values.

Whilst I think this is perfectly achievable, I've no knowledge as to
the likely performance. Would arrays be achievable and more
efficient?

Along the way I've also to sum 'pages' in col T, transfer summed
values to other sheets, do further summing and then transfer to a
final Summary sheet.

Unsure how to proceed, so any help/suggestions much
appreciated.

Regards.






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.571 / Virus Database: 361 - Release Date: 26/01/2004