diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellsCollection.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellsCollection.cs
index f7910cb..6d91072 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellsCollection.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellsCollection.cs
@@ -113,7 +113,13 @@
             if (rowsCollection.TryGetValue(row, out columnsCollection))
             {
                 columnsCollection.Remove(column);
+                if (columnsCollection.Count == 0)
+                {
+                    rowsCollection.Remove(row);
+                }
             }
+
+            
         }
 
         internal IEnumerable<XLCell> GetCells(Int32 rowStart, Int32 columnStart,
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs
index 9fa2aa3..26c40eb 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs
@@ -3599,7 +3599,7 @@
             var noRows = (sheetData.Elements<Row>().FirstOrDefault() == null);
             foreach (var distinctRow in distinctRows.OrderBy(r => r))
             {
-                Row row; // = sheetData.Elements<Row>().FirstOrDefault(r => r.RowIndex.Value == (UInt32)distinctRow);
+                Row row;
                 if (sheetDataRows.ContainsKey(distinctRow))
                     row = sheetDataRows[distinctRow];
                 else
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
index faf7d61..1c95938 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
@@ -1396,7 +1396,6 @@
 
             var namedRanges = Workbook.NamedRanges.FirstOrDefault(n =>
                                                       String.Compare(n.Name, cellAddressInRange, true) == 0
-                                                      && n.Ranges.First().Worksheet == this
                                                       && n.Ranges.Count == 1);
             if (namedRanges == null || !namedRanges.Ranges.Any()) return null;
             
@@ -1421,8 +1420,8 @@
 
             var namedRanges = Workbook.NamedRanges.FirstOrDefault(n =>
                                                        String.Compare(n.Name, rangeAddressStr, true) == 0
-                                                       && n.Ranges.First().Worksheet == this
-                                                       && n.Ranges.Count == 1);
+                                                       && n.Ranges.Count == 1
+                                                       );
             if (namedRanges == null || !namedRanges.Ranges.Any()) return null;
             return (XLRange)namedRanges.Ranges.First();
         }
diff --git a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs
index f28b5dd..7f73d0d 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs
@@ -16,13 +16,23 @@
         private static void Main(string[] args)
         {
             var wb = new XLWorkbook();
-            var ws = wb.AddWorksheet("Sheet");
-            ws.FirstCell().SetValue(1)
-                .CellBelow().SetFormulaA1("IF(A1>0,Yes,No)") // Invalid
-                .CellBelow().SetFormulaA1("IF(A1>0,\"Yes\",\"No\")") // OK
-                .CellBelow().SetFormulaA1("IF(A1>0,TRUE,FALSE)"); // OK
+            var ws = wb.AddWorksheet("Sheet1");
+
+            ws.FirstCell().SetValue("Hello")
+                .CellBelow().SetValue("Hellos")
+                .CellBelow().SetValue("Hell")
+                .CellBelow().SetValue("Holl");
+
+            ws.RangeUsed().AddConditionalFormat().WhenStartsWith("Hell")
+                .Fill.SetBackgroundColor(XLColor.Red)
+                .Border.SetOutsideBorder(XLBorderStyleValues.Thick)
+                .Border.SetOutsideBorderColor(XLColor.Blue)
+                .Font.SetBold();
+
+            
             wb.SaveAs(@"c:\temp\saved.xlsx");
             Console.WriteLine("Done");
+            Console.ReadLine();
         }
     }
 }
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/Ranges/RangeUsedTests.cs b/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/Ranges/RangeUsedTests.cs
index 7e6e693..5ec0500 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/Ranges/RangeUsedTests.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/Ranges/RangeUsedTests.cs
@@ -1,16 +1,36 @@
-using NUnit.Framework;
+using ClosedXML.Excel;
+using NUnit.Framework;
 
 namespace ClosedXML_Tests
 {
     [TestFixture]
     public class RangeUsedTests
     {
-        //[Test]
-        //public void FirstLastRows()
-        //{
-        //    var wb = new XLWorkbook();
-        //    var ws = wb.Worksheets.Add("Sheet");
+        [Test]
+        public void CanGetNamedFromAnother()
+        {
+            var wb = new XLWorkbook();
+            var ws1 = wb.Worksheets.Add("Sheet1");
+            ws1.Cell("A1").SetValue(1).AddToNamed("value1");
+            
+            Assert.AreEqual(1, wb.Cell("value1").GetValue<int>());
+            Assert.AreEqual(1, wb.Range("value1").FirstCell().GetValue<int>());
 
-        //}
+            Assert.AreEqual(1, ws1.Cell("value1").GetValue<int>());
+            Assert.AreEqual(1, ws1.Range("value1").FirstCell().GetValue<int>());
+
+            var ws2 = wb.Worksheets.Add("Sheet2");
+
+            ws2.Cell("A1").SetFormulaA1("=value1").AddToNamed("value2");
+
+            Assert.AreEqual(1, wb.Cell("value2").GetValue<int>());
+            Assert.AreEqual(1, wb.Range("value2").FirstCell().GetValue<int>());
+
+            Assert.AreEqual(1, ws2.Cell("value1").GetValue<int>());
+            Assert.AreEqual(1, ws2.Range("value1").FirstCell().GetValue<int>());
+
+            Assert.AreEqual(1, ws2.Cell("value2").GetValue<int>());
+            Assert.AreEqual(1, ws2.Range("value2").FirstCell().GetValue<int>());
+        }
     }
 }
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/ConditionalFormatting/CFStartsWith.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/ConditionalFormatting/CFStartsWith.xlsx
index c1191e4..7ccbbc2 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/ConditionalFormatting/CFStartsWith.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/ConditionalFormatting/CFStartsWith.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx
index 852a558..2052819 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx
index c3356ab..e8c5c58 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/DeletingRanges.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/DeletingRanges.xlsx
index 92aa072..c8ea574 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/DeletingRanges.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/DeletingRanges.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx
index 41a0ef2..6649869 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/Sorting.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/Sorting.xlsx
index c49f927..65c31ae 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/Sorting.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/Sorting.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/TransposeRanges.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/TransposeRanges.xlsx
index 3701fbb..6f8b669 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/TransposeRanges.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/TransposeRanges.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/TransposeRangesPlus.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/TransposeRangesPlus.xlsx
index 7035634..986d564 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/TransposeRangesPlus.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/TransposeRangesPlus.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/UsingTables.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/UsingTables.xlsx
index eb5feee..4c1881c 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/UsingTables.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/UsingTables.xlsx
Binary files differ