Posted to microsoft.public.excel.programming

Curt D.

external usenet poster

Posts: 20

Deleting first empty row along with the next 700 rows

I have some data that I am trying to use the sumproduct formula on but I keep
getting the VALUE! code unless I delete the next 700 or so rows that have no
data in them. The number of rows with data changes so I can not just look at
certain number of rows. Does anyone have a way in VBA to select the first
emoty row and the next 700 rows (approx) and then delete them? Thanks in
Advance for the help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
deleting empty rows	EngelseBoer	Excel Discussion (Misc queries)	3	September 7th 08 01:09 AM
Deleting Empty Rows	Darryl	Excel Programming	3	June 20th 06 10:52 PM
Deleting All Empty Rows	bodhisatvaofboogie	Excel Discussion (Misc queries)	3	May 18th 06 12:36 PM
Deleting empty rows	edward0380	Excel Programming	4	December 6th 05 07:51 PM
Deleting empty rows	Foss	Excel Programming	4	June 4th 04 07:41 AM

All times are GMT +1. The time now is 11:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us