ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Switch Multiple Rows In Pivot (As Viewer) Hi ILLIA I changed the action code with your changes. it affects only the "clear sub rows ..." option can you check why the first part (until the else) of the code does not work? thank you Dov