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: 2
Default Find blank cells and clear adjacent range


While I know how to find blank cells and delete complete rows, how do I
find all the blank cells in column C and clear the cell contents of the
next 5 cells to the right?

Grateful for some advice.
--
rbel
 
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
Sum only if cells are not blank in adjacent column arch0072 Excel Worksheet Functions 4 September 2nd 08 09:44 PM
Find used range and ignore blank cells when running macro? Rick S. Excel Programming 3 October 3rd 07 02:52 PM
Clear Blank cells choice[_2_] Excel Programming 0 September 23rd 07 12:32 AM
clear range of cells if another becomes blank bgg Excel Worksheet Functions 3 January 17th 07 11:32 PM
find range of non-blank cells in colum DJS Excel Programming 3 June 26th 06 10:27 PM


All times are GMT +1. The time now is 08:30 PM.

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

About Us

"It's about Microsoft Excel"