Advertisement
Johniny

Notes: Find Last Row and Pivots

Mar 11th, 2020
352
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. Find last row: https://www.excelcampus.com/vba/find-last-row-column-cell/comment-page-1/
  2. Intersect(Activecell.CurrentRegion, ActiveCell.EntireRow) //pouzitelne na oznacenie celku buniek
  3. Ako nastavit format?: https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfield.numberformat
  4. := https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfields
  5.  
  6.  
  7.  
  8.  
  9. https://www.thespreadsheetguru.com/blog/2014/9/27/vba-guide-excel-pivot-tables
  10. https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfield //k tomuto objektu je kopec užitočných methods a properties, len si prelistovat
  11. napriklad: https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfield.clearmanualfilter //vycisti filter v danom poli!
  12. napriklad: https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfield.numberformat //nastavi format (String ako do Excelu, nie VBA)
  13. napriklad: https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfield.repeatlabels //ci bude len prva polozka daneho druhu alebo na kazdom riadku
  14. a iné
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement