In this video, you'll learn more about what named ranges are in Excel Visit https//wwwgcflearnfreeorg/exceltips/ to learn even moreWe hope you enjoy! Excel names the ranges with valid names, based on your headings ;IF wert2 > 26 Then Range(Chr(wert1), Chr(65) & Chr(wert2 65)) Das funktioniert dann aber wieder nur bis Spalte AZ!!

Add Named Range In Excel 365 Archives Geek Excel Become An Excel Geek