Add range.Addvalue extension

1 files changed, 13 insertions, 0 deletions

diff --git a/src/AddIn/WorksheetExtensions.cs b/src/AddIn/WorksheetExtensions.cs
index 51ce13a..cffa55c 100644
--- a/src/AddIn/WorksheetExtensions.cs
+++ b/src/AddIn/WorksheetExtensions.cs
@@ -27,6 +27,19 @@ namespace RehauSku
 
             return cells.All(x => x != null);
         }
+
+        public static void AddValue(this Range range, double value)
+        {
+            if (range.Value2 == null)
+            {
+                range.Value2 = value;
+            }
+
+            else
+            {
+                range.Value2 += value;
+            }
+        }
     }
 }