Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filter for missing values in a range | Excel Discussion (Misc queries) | |||
Missing Blue Border in xml mapped range | Excel Discussion (Misc queries) | |||
Missing blank in Dynamic range | Excel Worksheet Functions | |||
Rounding a large range & a Missing Font | New Users to Excel | |||
Advanced Filtering Extract Range Missing,etc | Excel Worksheet Functions |