Works for me. I added: Set rng = Selection.Cells
Also, those values in the next column should be numeric. Better check.
Portland, Oregon USA
(review of excel sorting add-in)
I have a worksheet containing cells having text in Column A & in
Column B i have cells having formulae in them. column. Using VBA, i am
trying to increase / decrease font size of Column A text, based on the
formula value returned in Column B cell.
for each rr in rng
if rr.offset(0,1).hasformula then
right now, i am unable to get the value returned by the formula using
VBA. How to achieve this?