Posted to microsoft.public.excel.programming

Piers 2k

external usenet poster

Posts: 11

Skipping a set number of rows

Do Until ActiveCell.Offset(10,0).Value = ""
' more stuff here
ActiveCell.Offset(10,0).Select
Loop

Something like that should do the trick.

Piers

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Skipping rows	Rob	Excel Worksheet Functions	1	March 4th 10 04:52 PM
Copy while skipping Rows	Will	Excel Discussion (Misc queries)	3	December 15th 06 05:25 AM
Skipping rows with VBA	Jeff	Excel Discussion (Misc queries)	4	April 24th 06 06:48 PM
Trouble with skipping rows	Wazooli	Excel Worksheet Functions	1	March 23rd 05 02:19 PM
Macro skipping even rows	Bob Phillips[_5_]	Excel Programming	5	July 26th 03 12:29 PM

All times are GMT +1. The time now is 02:47 PM.

About Us

"It's about Microsoft Excel"