| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you test for a range (Q16:19) any cell is ISBLANK
I'm running a piece of code that loop and that basically writes a column of 4
cells over itself to permanently change the data created by other calculations to be static. So as an example on the first pass its going to write over Q16:19. ActiveSheet.Range("Q" & j + 5 & ":Q" & j + 8).Value = ActiveSheet.Range("Q" & j + 5 & ":Q" & j + 8).Value My question is Id like to test before writing over this data is all 4 cells have data (or that none are left blank). Is there a single command to test a rage of cells (Q16:19) to all be non-null. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test if CELL is in RANGE | Excel Worksheet Functions | |||
| test if column isblank | Excel Worksheet Functions | |||
| logical test for each and every cell in range | Excel Discussion (Misc queries) | |||
| Test to see if a cell is within a range | Excel Programming | |||
| Test if Cell is within Range (name) | Excel Programming | |||
Threaded Mode
