Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm doing validation checking on a spreadsheet whose data will be
imported into a data base if the spreadsheet's formatting and layout look right. On a given worksheet, once I think I've found the last row of data, I'd like to set a .Range=(a whole bunch of cells after what I think is the last data row) and then check to see if there are any values in the composite of all those cells. If there are any values, that would suggest that the worksheet's format is wanting and I'd inform the user accordingly. Bottom Line: If I've got a Range, is there a syntactically-simple way to see if there's any data in it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
More Concise Way To Assign Borders? | Excel Programming | |||
Make instructions clear, concise and in plain english. | Excel Discussion (Misc queries) | |||
Concise border removal method | Excel Programming |