Anne you don't need a macro for this a simple formula will suffice,
however if you really want a macro could you tell me what "42" in column
B is? is it 42 items? a numeric value in any cell equating to 42?, a sum
of all column B being equal to or greater than 42?, or a text value
"42"?

Anne;407286 Wrote:
Hello!
I have a worksheet with cols. A, B, C, D, and E. I want to do an
if-then
statement in a macro that says, If B has "42" in it (no matter how long
the
worksheet is, because they will vary widely), then divide the amount
paid (E)
by 2.

B1 will always have Fund as its name; E1 will always have Amount Paid.
As
mentioned, the size of the worksheet may vary a lot, so I was thinking
I'd
use a range, but I'm not sure how to.

Example:
Columns
A B C D E
Row
1 Dept. Fund Vendor Desc Amount Paid

2 100 42 X Y 100.00

3 100 43 Z A 100.00

4 101 43 M G 100.00

After the code ran, E2 would be 50.00.

I'd like to put this in as a module, to make a little macro button for
it.
(I know how to do that.) Any help would be appreciated. --Anne


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113514