Inhalt von Zelle als Name von Tabellenblatt VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-3244776%22%20slang%3D%22de-DE%22%3EContents%20of%20cell%20as%20name%20of%20worksheet%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3244776%22%20slang%3D%22de-DE%22%3EHello%2CI%3CBR%20%2F%3E%20have%20the%20following%20CodeDim%3CBR%20%2F%3E%20SheetName%20As%20StringBlattName%3CBR%20%2F%3E%20%3D...%3CBR%20%2F%3EAt...%20Should%20now%20be%20the%20contents%20of%20cell%20C1%20of%20the%20worksheet%20%22Auxiliary%20Table%22.%20Unfortunately%2C%20I%20am%20an%20absolute%20beginner%20in%20VBA.%20Does%20anyone%20have%20a%20solution%20for%20me%3F%3CBR%20%2F%3EThank%20you%20in%20advance.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3244776%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3244866%22%20slang%3D%22en-US%22%3EBetreff%3A%20Inhalt%20von%20Zelle%20als%20Name%20von%20Tabellenblatt%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3244866%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1314497%22%20target%3D%22_blank%22%3E%40Blogie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-visual-basic%22%3E%3CCODE%3EDim%20BlattName%20As%20String%0ABlattName%20%3D%20Worksheets(%22Hilfstabelle%22).Range(%22C1%22).Value%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor
Hallo,
ich habe folgenden Code
Dim BlattName As String
BlattName =...
Bei... Soll nun der Inhalt der Zelle C1 vom Tabellenblatt "Hilfstabelle" stehen. Ich bin leider absoluter Anfänger in VBA. Hat jemand eine Lösung für mich?
Vielen Dank Sinn mal im voraus.
1 Reply

@Blogie 

Dim BlattName As String
BlattName = Worksheets("Hilfstabelle").Range("C1").Value