skipping blank lines

[Megatron-Lives]

I got on C. Pearson's site, and looked at his code for this, and downloaded his demo of it, and it works well and fine on his demo, but i cannot make it work elsehwere at all; the best i can make it work is for the first line; every other line returns a #num... p.s. this is what i am looking at

http://www.cpearson.com/excel/noblanks.htm

 

[Mark O'Brien]

Two things spring to my attention here:

1. Do you have a range named "BlanksRange"? or have you adapated the formula to suit your needs?

OR (more likely in my opinion, based on your problem

2. When using this formula, which is an array formula, have you entered the formula by holding CTRL + SHIFT when hitting ENTER?