Removing blank cells in a large matrix

Hi

I see your post is marked as solved. Could you please share how you solved it? I found your problem interesting and managed to solve it myself but it would be fun to compaire solutions.

Alf

Hi-

I gave up and spent about 1/2 hour just deleting the blank cells. I played with some "delete empty cell" macros I found on the web but with no success. Did you find a simple solution? My friend lives by Gothenburg and is interviewing for a job at the Gothenburg Arboretum. thanks for your response!

Hi

This is the code I used to solve your problem. I ran it on the compleate "weather file" and I got 1054 rows of data so it seem to work ok but you better check the result just to be sure.

Hope your frien gets a job in Gothenburg!

Ps I'm using Excel 2003 and you are using 2007 but I don't think there will be any problem

Strange, previewing post and line "GoTo ****" get changed to "GoTo ****"
and "****:" changed to "****:"

Please Login or Register  to view this content.

Oh, I got it. The swedish word for "End" meens a female of ill repute in english.

Better write "GoTo stoppa" and "stoppa:" I little bit of swedish will not hurt you