-
Compting 99% of a col range while autofilter is on.
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
-
Is this what you're after?
[VBA]
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
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules