Pam
What range in each row do you want to name and what do you want to name
it? Otto

"Pam" wrote in message
...
Hi,

I have a spreadsheet with a column for Department that contains numbers.
I would like to be able to sort by Department and then use vba code to
name a range for each department number and then use the range name in
conditional formatting. This is something that I have to do on a weekly
basis with a new list downloaded to Excel, so I would really like to
automate as much as I can. Is this possible?

Thanks in advance for any help.
Pam