Help modifying code to check for text in a range prior to email sheet.

**dcgrove** · 07-09-2009, 05:16 PM

Hello, I am using the code below tied to a button on the worksheet to email a sheet and would like it to check that there has been text entered intothe cells below prior to emailing the sheet. If the cells have no text entered i would like a message box to pop up stating that all fields need to be completed.

Range of cells:
H6,A9,F9,A12,F12,A16,A23,A26,C28,D30,D32,D34,A37,D39,F36,F28

Email code I am using:

Please Login or Register  to view this content.

I tried to adapt this code, but it is far to advanced for me to wrap my head around. If it could be made to check the range of cells I have provided prior to the execution of the code above that would be fantastic.

Please Login or Register  to view this content.

Thank you for any help you may be able to provide!

This is posted at VBAexpress.com as well.

Clayton

**dcgrove** · 07-09-2009, 05:56 PM

hello, I am trying to use 16 cells below and it is failing. It does not fail when I only have one cell. Is there a limit to how many cells you can put in there?

Please Login or Register  to view this content.

What I am trying to accomplish is that if any of these cells are empty to kill the whole macro. This code is part of a larger one I use. I could write an if statement for each cell, but I am trying to simplify and shorten the process (and learn something new)!
Thanks!

Clayton

**DonkeyOte** · 07-09-2009, 05:58 PM

[removed - garbage! - apologies]

**dcgrove** · 07-09-2009, 06:01 PM

Donkeyote, that code fails to an error message stating "compile error: wrong number of arguments or invalid property assignment."

Any ideas? My original code failed to same message.

**DonkeyOte** · 07-09-2009, 06:05 PM

What is the content of the cells when populated - text / number / mix ?

I removed my last post as it was nonsense - aparat from the syntax error COUNTBLANK does not accept non-contiguous ranges... COUNTA / COUNT do so you could potential use that rather than:

Please Login or Register  to view this content.

**dcgrove** · 07-09-2009, 06:07 PM

Some cells will be text, some numbers and some both.

**Paul** · 07-09-2009, 06:10 PM

How about:

Please Login or Register  to view this content.

**shg** · 07-09-2009, 06:11 PM

Or ...

Please Login or Register  to view this content.

**DonkeyOte** · 07-09-2009, 06:11 PM

I merged your two threads - please try to keep to one thread going forward.

Re: Paul's COUNTA approach - this will work unless the cells are populated with formulae Nulls - let us know.

**dcgrove** · 07-09-2009, 06:16 PM

Thanks everyone for the help and thanks donkeyote for merging the threads. Pauls code solved my problems. You guys rock!

clayton

Help modifying code to check for text in a range prior to email sheet.

LinkBack

Thread Tools

Rate This Thread

Display

Help modifying code to check for text in a range prior to email sheet.

using 16 cells in "If Range("XX","XXY)" is failing

Re: using 16 cells in "If Range("XX","XXY)" is failing

Re: using 16 cells in "If Range("XX","XXY)" is failing

Re: using 16 cells in "If Range("XX","XXY)" is failing

Re: using 16 cells in "If Range("XX","XXY)" is failing

Re: using 16 cells in "If Range("XX","XXY)" is failing

Re: Help modifying code to check for text in a range prior to email sheet.

Re: Help modifying code to check for text in a range prior to email sheet.

Re: Help modifying code to check for text in a range prior to email sheet.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions