defining

Dear, No problem for defining a name for a single data range. However, I have situation to make a frequency table using data in two separate ranges, for example B2:C5 and D2:E6. Is there a way to define these two ranges as one name so I can use '=frequency(the name, bin range)?' Thank you, joylee

I have a print problem with a macro. I am printing a label so my temporary sheet needs to have a print area defined and I am trying to define B1:C10 of a sheet but I keep getting each column defining itself as a page. I can record it but it will not allow me to use that language in the code. It...

I want to count the number of cells that have a shaded color lets say yellow. Can I do this without VB? If so how? I remember once defining the color as a number somewhere but forget how I did that. any help would be great. thanks Heller

Hi there, I am trying to create a tracker for my work, I work co-ordinating different types of repair staff around the UK. I have to make a function that allocates what region of the country an entry is for, there are 25 locations and they are spread so; Region 1 : 9 Locations Region 2 : 9...