title: VBA for formula to values in a filtered range
body: <p>Sometimes, I need to run a formula on a selection of a filtered range and then convert it to values, every time I want to <code>copy</code> and then <code>special paste values</code>, I must clear the filters first. I need a <code>macro</code> that will convert the formula to values without clearing the filters, I also want to use a shortcut key for this operation.</p>