Zack,

I know I could put the following formula in Column I2 and copy it all the
way down the sheet in all cells to I6553:
=F2-H2
But doing this makes my spreadsheet HUGE, so I was looking for a way to do
the above in VBA vice using a formula.

Thanks again,
Kevin

"zackb" wrote in message
...
Does this not suit your needs? If not, can you explain what you need
differently here? Will this be dependent on some rows? Any headers?
Only
to a certain row?

--
Regards,
Zack Barresse, aka firefytr

"Kevin Baker" wrote in message
news:P4dee.669$It1.624@lakeread02...
Here is what I have:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 And Target.Value 1 And Target.Offset(0, 2).Value
1
Then
Target.Offset(0, 3).Value = Target.Value - Target.Offset(0, 2).Value
End If
End Sub



"Kevin Baker" wrote in message
news:vWcee.667$It1.55@lakeread02...
Hi all.

It seems when I use a formula (the formula would need to be in the
entire
column of "I") the spreadsheet file size is very large, however, it
seems
when I use VBA code the file size doesn't grow as much.

In my spreadsheet column "I" would be the difference between the value
in
Column "F" and Column "G".

Does that make sense?

Thanks for all your help,
Kevin
"zackb" wrote in message
...
Hi,

Depending on where you want it to go, I'm making some assumptions here
...

Range("A1").Value = Range("F2").value - Range("H2").value

or

Range("A1").formula = "=F2-H2"

--
Regards,
Zack Barresse, aka firefytr

"Kevin Baker" wrote in message
news:UPbee.660$It1.521@lakeread02...
Would like to use VB Code to do the following:

=F2-H2

Thanks,
Kevin