I have a range, let's call it myRange that's cells B22:B24 in my worksheet.
I need to check that these cells are all not blank before doing something
else. I'm not sure how to write the code to check that all are non-blank.
Any suggestions?

Thanks

See your other thread

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Barb Reinhardt" <(E-Mail Removed)> wrote in message
news:0F35A096-1A55-4B48-9E7D-(E-Mail Removed)...
>I have a range, let's call it myRange that's cells B22:B24 in my worksheet.
> I need to check that these cells are all not blank before doing something
> else. I'm not sure how to write the code to check that all are non-blank.
> Any suggestions?
>
> Thanks

Ron,

I've gotten several messages indicating this wasn't posted when I first
posted it. That's why there are multiple threads. UGH!

Thanks for the response.

Barb

"Ron de Bruin" wrote:

> See your other thread
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Barb Reinhardt" <(E-Mail Removed)> wrote in message
> news:0F35A096-1A55-4B48-9E7D-(E-Mail Removed)...
> >I have a range, let's call it myRange that's cells B22:B24 in my worksheet.
> > I need to check that these cells are all not blank before doing something
> > else. I'm not sure how to write the code to check that all are non-blank.
> > Any suggestions?
> >
> > Thanks
>
>
>

Use Outlook Express for newsgroups

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Barb Reinhardt" <(E-Mail Removed)> wrote in message
news:8F6241A6-C288-42FB-9CFC-(E-Mail Removed)...
> Ron,
>
> I've gotten several messages indicating this wasn't posted when I first
> posted it. That's why there are multiple threads. UGH!
>
> Thanks for the response.
>
> Barb
>
> "Ron de Bruin" wrote:
>
>> See your other thread
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Barb Reinhardt" <(E-Mail Removed)> wrote in message
>> news:0F35A096-1A55-4B48-9E7D-(E-Mail Removed)...
>> >I have a range, let's call it myRange that's cells B22:B24 in my worksheet.
>> > I need to check that these cells are all not blank before doing something
>> > else. I'm not sure how to write the code to check that all are non-blank.
>> > Any suggestions?
>> >
>> > Thanks
>>
>>
>>