LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default If empty, then display message

Hi, i need this code to display a message if next or last (when it finds
first empty cell) cell in A1:L1 is empty.

=INDEX(A1:L1,MATCH(MONTH(TODAY()),MONTH(A2:L2)-1))
Can this be done?
Thanks!
 
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
Message: 'Cannot empty clipboard' Terry Pinnell Excel Discussion (Misc queries) 2 May 27th 09 09:11 AM
Message: Cannot empty clipboard Terry Pinnell Excel Discussion (Misc queries) 2 May 22nd 09 12:39 AM
Error message: Cannot empty the clipboard. Carolyn Excel Discussion (Misc queries) 1 December 27th 06 07:28 PM
Error Message: Cannot Empty the Clipboard Prema New Users to Excel 0 January 2nd 06 10:02 PM
Error Message "Cannot Empty Clipboard" Robert Setting up and Configuration of Excel 1 September 17th 05 12:29 AM


All times are GMT +1. The time now is 03:08 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"