Simple VBA
On Sun, 9 Aug 2009 21:58:43 -0600, "Tony" wrote:
I can make vlookup work, but it is very inconvenient. It would be much
better if I could make my technique work.
I think I'll keep at it. Rather than have the Income_Tax worksheet do the
logic of figuring out the tax, I could have VBA do it but reference the
amounts from the Income_Tax worksheet.
You could have the tables stored on a worksheet, and then reference that sheet
in your VBA routine. (Of course, you could also hard code them into VBA
arrays).
In the US, I would use the 2009 Tax Rate Schedules (published on the IRS form
1040-ES, to do this.
--ron
|