Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Dim myRange As Range With shtSheet .Range(.Cells(1, 2), .Cells(1, 255)).Name = strBereichsName End With ' Hide the new sheet. ' shtSheet.Visible = xlSheetHidden 'Hide the new range ActiveWorkbook.Names(strBereichsName).Visible = False ' End major changes to code ********************************* On Error GoTo errdaten With AktiveZelle.Validation 'Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=" & strBereichsName .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = True .ShowError = True End With
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel 2016 - Link to (or reference) sheet within another workbook||9||60|
|Import / Pull out data with condition from various excel registers to main excel file||10||56|
|Issue with nested if statement and vlookup formula||4||43|
|Could not use "; file already in use EXCEL 2016 VBA||3||6|
Join the community of 500,000 technology professionals and ask your questions.