I am having the EXACT same problem in trying to create a macro to appl
to a histogram.

I have re-recorded at least a dozen times and tried just about ever
option.

The only thing I thought of is that the input values are results o
formulae and not direct cell entry. However, I did direct cell inpu
and got the same results.

The macro code is exactly the same as the first post by randysbu
except I'm not using a shortcut. I plan to make it a worksheet even
since my tables are being updated from another area of the workbook.

Was this one solved and what was the solution?

Thanks!!

RHer

--
Message posted from http://www.ExcelForum.com