Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compting 99% of a col range while autofilter is on.
If you're changing the values of the visible cells to 99%, you can
select the range Edit|Goto|special|visible cells only type: 99% hit ctrl-enter to fill all those visible cells with that value. If you're pasting, then your range to paste has to be contiguous--maybe you can sort first, then paste, then resort your data. Aligahk06 wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter a Date range | Excel Discussion (Misc queries) | |||
Limiting the range of AutoFilter? | Excel Worksheet Functions | |||
Numbering a Range Using Autofilter | Excel Discussion (Misc queries) | |||
What is Range For Chart AutoFilter Range VBA? | Excel Discussion (Misc queries) | |||
Dynamic series range from AutoFilter | Charts and Charting in Excel |