Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Find last row: https://www.excelcampus.com/vba/find-last-row-column-cell/comment-page-1/
- Intersect(Activecell.CurrentRegion, ActiveCell.EntireRow) //pouzitelne na oznacenie celku buniek
- Ako nastavit format?: https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfield.numberformat
- := https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfields
- https://www.thespreadsheetguru.com/blog/2014/9/27/vba-guide-excel-pivot-tables
- 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
- napriklad: https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfield.clearmanualfilter //vycisti filter v danom poli!
- napriklad: https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfield.numberformat //nastavi format (String ako do Excelu, nie VBA)
- napriklad: https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfield.repeatlabels //ci bude len prva polozka daneho druhu alebo na kazdom riadku
- a iné
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement