For each....that is not blank

Posted to microsoft.public.excel.programming

Aria[_2_]

external usenet poster

Posts: 34

For each....that is not blank

Hello,
How do you change this line to become For Each c in the range of B2 to
B12 that is Not Blank?

For Each c In Sheets("Inventory").Range("B2:B12")

:) Aria

*** Sent via Developersdex http://www.developersdex.com ***

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
Index/match - make blank cells return a blank value.	diaare	Excel Worksheet Functions	3	May 3rd 23 03:44 AM
Excel 2002: Return blank when VLOOKUP on blank cells	Mr. Low	Excel Discussion (Misc queries)	2	June 4th 09 05:12 PM
Average Formula to display blank cell if named range is blank	Rachael F	Excel Worksheet Functions	3	February 22nd 08 05:05 PM
Macro code to test for blank row and insert blank row if false	Mattie	Excel Programming	2	March 29th 06 01:19 AM
Copying and pasting a worksheet to a blank and removing blank rows	Bob Reynolds[_3_]	Excel Programming	0	June 24th 04 02:55 PM

All times are GMT +1. The time now is 10:08 AM.

Menu

About Us