Post your code...
--
HTH...

Jim Thomlinson


"Carlee" wrote:

Hi there,
I am using a case statement that where a condition state exists, a column of
values are populated for a specific month using: range("AI7") =
Range("J97"). I have about 30 of these statements, for twelve conditions.

Problem: this takes a long time to execute. Is there a faster way?
--
Carlee