Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

Excel VBA Cheat Sheet Cheat Sheet (DRAFT) by

VBA

This is a draft cheat sheet. It is a work in progress and is not finished yet.

Letzte Zelle used Range

Active­She­et.U­se­dRa­nge.Sp­eci­alC­ell­s(x­lCe­llT­ype­Las­tCe­ll).Row

Letzte Zelle A

Active­She­et.C­el­ls(­Row­s.C­ount, 1).End­(xl­Up).Row
 

Cells

ThisWo­rkb­ook.Sh­eet­s("Neuer Eintra­g").C­el­ls(4, 3)
4= Zeile
3=Spalte

Offset

.Offse­t(1,2)

Eine Zeile hinunter, zwei Spalten rechts
   
           
 
Advertisement