Posted to microsoft.public.excel.misc

kevcar40

external usenet poster

Posts: 78

Fill Blank cells in a range

Hi
I have a worksheet that i import data onto
i then count the number of rows and store the result in AM1
the problem is some of the cell are blank
What i want to do is check the range
from BH1 to BH (AM1 value) checking for Blank cells
if any are found put the Word "BLANK" in the cell

Thanks

Kevin

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
Fill in blank cells	Ian	Excel Discussion (Misc queries)	3	December 15th 06 08:06 AM
automatically fill in blank cells??	AlaskaMX	Excel Worksheet Functions	6	September 5th 06 05:32 PM
Fill blank cells with spaces	[email protected]	Excel Worksheet Functions	6	March 22nd 06 09:17 AM
FILL IN BLANK CELLS	Charles	Excel Discussion (Misc queries)	2	August 8th 05 07:07 PM
Fill blank cells	jenny	Excel Discussion (Misc queries)	2	January 7th 05 02:33 PM

All times are GMT +1. The time now is 12:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us