Your description leaves a lot of holes.

'continue through each column and row of the 1st sheet until the range is
complete.'

Which range? Column B? Row 2? UsedRange? Describe the range. If it is no
all numeric, there is no need to subtract strings.

The assumption would be the the seventh cell below another should be
subtracted on each iteration.

How do you want the results entered into the new worksheet? Continue down
column B? Continue across Row 2?


"caveman.savant" wrote in message
...
I would like to create a new worksheet and create values based on an
active sheet

(example sheet at
http://spreadsheets.google.com/ccc?k...5oUSDoqTgI6sRA
)


The macro would look at the active sheet and subtract the value of B9
from B2 and put the result into a new sheet at B2. It would continue
through each column and row of the 1st sheet until the range is
complete.