LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default Need simple code to skip blank rows

I have a worksheet that has blocks of part/order numbers that have to
be sorted by date and segmented with a blank row between each block. I
know it's not the best practice to have blank rows in between data but
thats what management wants. So I need help with code to search through
this worksheet, ignore 1 blank row between each segment, and find the
end of the data on the sheet. At that point I will insert another blank
row then insert data from a Sales Order which I have already coded.

I appreciate any help,

Thank you,

Chad

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Need to number but skip blank rows FJ Excel Discussion (Misc queries) 7 August 19th 09 10:50 AM
copy from one sheet to another and skip the blank rows Dawn Excel Discussion (Misc queries) 3 March 11th 09 07:46 PM
VBA code to hide blank rows ub Excel Worksheet Functions 4 July 31st 08 01:44 PM
simple code hide/show rows with cell = empty, set value or any val ivory_kitten Excel Programming 4 July 18th 06 02:27 AM
skip blank rows when pasting formulas Newsgal Excel Worksheet Functions 1 June 22nd 05 10:13 PM


All times are GMT +1. The time now is 03:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"