The Select Case statement is designed for this type
of "multiple condition 'if'"
Select Case MonthNo
Case 1, 2, 3
qtr1 = .....
Case 4, 5, 6
qtr2 = ....
Case 7, 8, 9
qtr3 = ...
Case Else
qtr4 = ...
End Select
-----Original Message-----
Please help. I need to write a couple lines of codes in
excel to tell
the worksheet if it's month 1,2,3 then place a certain in
qtr1, if the
month number is 4,5,6 then place the value in qtr2. I
don' think it's
too complicated but being new to vba.....i'm
helpless....thanks for all
your help.
Tami
---
Message posted from http://www.ExcelForum.com/
.