LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Missing Data in a Range

Is there a simple code to search a known range to verify
that each cell has correct data? The catch here is that
I always use columns A thru H, but do not know how many
rows it will be each time. So if I have complete
information on rows 2 - 5 (with row 1 as a header), then
I have only 1 column with data on row 6--it should
trigger a msgbox, etc...

I currently use a Do...Loop Until IsEmpty and then again
check the entire row, but this is quite slow in my
opinion, surely there could be a faster way.

Thanks if you could help, or let me know if I should
provide more detail.
 
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
filter for missing values in a range billnock Excel Discussion (Misc queries) 1 January 30th 10 11:01 PM
Missing Blue Border in xml mapped range Babba Excel Discussion (Misc queries) 0 October 26th 06 11:54 AM
Missing blank in Dynamic range Graham Haughs Excel Worksheet Functions 5 August 4th 06 10:59 PM
Rounding a large range & a Missing Font Jay New Users to Excel 1 May 21st 06 06:50 PM
Advanced Filtering Extract Range Missing,etc bridges_22 Excel Worksheet Functions 1 February 6th 06 04:19 PM


All times are GMT +1. The time now is 06:18 AM.

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"