Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA over-write identical worksheet-ranged-cells only if receiving sheet's cell is empty
2003-2007
VBA over-write identical worksheet-ranged-cells only if receiving sheet's cell is empty Facts: Sheet1 has range Named "FirstDataSet" of cells A1-Z100 Cells in "FirstDataSet" contain data in about 20% of the cells Sheet2 has range Named "SecondDataSet" of cells A1-Z100 Cells in "SecondDataSet" contain data in about 20% of the cells - ... but not the same data in similar ranged-cells. I realize that I could: For each myCell in FirstDataSet If myCell.value < "" myCell.value = SecondDataSet.Range(same range as myCell).value End if Next myCell Is there a smarter/efficient way to use broader range base than Each myCell? My guess is no - because the evaluation is on a cell by cell basis?? But I am open to learn! TIA EagleOne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write a macro that hides rows based on empty cells | Excel Discussion (Misc queries) | |||
find empty cells in a column then append row that empty cell is in | Excel Programming | |||
Adding/Removing Rows to Referenced Ranged in Worksheet | Excel Programming | |||
Adding up cell values only with identical info in other cells | Excel Worksheet Functions | |||
How do I link an identical cell address across multiple worksheet. | Excel Worksheet Functions |