Re: Problems deleting filtered rows

The problem is that it seems to be a random problem, because when I was testing your advice on the spread*** with problems it started working fine.

That's the problem

When you can reproduce it every time it is easier to create a bug report.



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rodrigo Alonso" <ralonso@xxxxxxxxxxxxxx> wrote in message news:eDe%23rFJdIHA.1824@xxxxxxxxxxxxxxxxxxxxxxx
Hello Ron:
Thanks for your help.
The problem is that it seems to be a random problem, because when I was testing your advice on the spread*** with problems it started working fine.
In any case, I will have your advice at hand for the next time I run into the problem.
It also allow me to learn about your webpage.
Thanks again.
Regards,
Rodrigo Alonso


P.S. But certainly it is a very annoying situation not to know if the program works or not.

"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> wrote in message news:%23RMSiBAdIHA.4332@xxxxxxxxxxxxxxxxxxxxxxx
hi Rodrigo
You are not the only one
I only see this problem myself when I filter in a table in 2007 but not with Autofilter

You can do this (part of one of my webpages)

1) Select the whole data range or if you not have empty rows/columns in the range you can use Ctrl * to select all data or use F5>Special>Current region>OK with one cell selected in the data range.
If it copy all the data (there are a few reports of 2007 users) use also the shortcut
Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rodrigo Alonso" <ralonso@xxxxxxxxxxxxxx> wrote in message news:uPbfD%23$cIHA.3788@xxxxxxxxxxxxxxxxxxxxxxx
I usually use the Filter function when dealing with data in Excel.
But I cannot figure out why SOMETIMES the hidden data (i.e. after being filtered) is also afected by changes to filtered data. For example, if I use Filter to find blanks cells and then delete the filtered rows also hidden rows (with data) are deleted.
I am using Excel 2007, and I never had this problem before with earlier versions of Excel.
I will appreciate any help regarding this problem
Thanks.

.

Quantcast