View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Selecting all cells of a certain fill (interior) colour (macro

Hi Neil,

For the purpose of providing the background colour, whilst retaining the
pre-determined range colours, Peter's suggestion is a good one.

My reference to John Walkenbach's Color Picker was based on the (possibly
inappropriate) assumption that each student would set and change the
background colour arrangement.

If, conversely, this operation is to be performed by you, or a colleague,
the Colour Picker would be unnecessary.

---
Regards,
Norman



"Neil Goldwasser" wrote in
message ...
Thanks for your reply Norman. Unfortunately though, naming my "input
cells"
still doesn't quite work. Maybe it is just this particular worksheet
(would
it dislike merged cells perhaps?). If I select the 30-odd cells I want to
name under one group (e.g. naming it Input_Cells), click off these cells,
choose Go To Input_Cells,.... it only remebers some of those 30-odd cells
but
not all of them - very frustrating!

I've had another go just now, but no joy.

Any thoughts on why it's playing me up?