Compting 99% of a col range while autofilter is on.

[aligahk06]

Dear All,

I am in filter mode while copying and pasting in filter mode generated error cannot paste.
In filter mode i have column which consists of numerical value.
Being in Auto filter mode i want some column range Let it Be start from G11 and upto G...
I want to change the value of numerical value Col G as 99%.( Auto filter is on)

Is there any way or macro to do this ?

Please assist ?

Rgds,
Aligahk06

[mdmackillop]

Is this what you're after?

Sub Do99()
For Each cel In Range(Cells(11, 7), Cells(Rows.Count, 7).End(xlUp)).SpecialCells(xlCellTypeVisible)
cel.Value = 0.99 * cel.Value
Next
End Sub