PDA

View Full Version : Prevent Blank Rows When applying filters



plasteredric
03-01-2018, 04:24 PM
I'm having issued with a spreadsheet, when i filter the data I have the category: Blanks in the drop down. When applying the filter and later removing them the row order sometimes changes and I find blank rows in the middle of the data.

Has anyone else experienced this? i'm thinking it may be because I have formulas pre populated in the table meaning some rows contain no data & just the formulas.

If I am correct, is there a way of (using vba) to populate the formulas into only the rows that contain data?

Any help appreciated

thanks

werafa
03-02-2018, 04:57 PM
to write a formula in vba, use range/cell.formula property

eg

myRange("A1").formula = "=B1+C1"

Can't say I've ever seen filters change data order - I use them specifically because they don't......