SOLVED: ‘You Can’t Change Part of an Array’ Error in Excel – How to Sort UNIQUE Formulas
Автор: Something Great
Загружено: 2024-12-15
Просмотров: 259
Описание:
I know there are better ways to do this rather than using unique formulas but sometimes I need to use a unique formulas and found a way to sort the list. Hope you find it useful!
P.S. ignore my comment about Power Query Editor being a back end version of pivot tables idk what I was thinking.
Query code used in the video:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim MonitoredRange As Range
Set MonitoredRange = Me.Range("B4:C35")
If Not Intersect(Target, MonitoredRange) Is Nothing Then
Application.EnableEvents = False ' Prevent re-triggering
ThisWorkbook.Connections("Query - Table").Refresh
Application.EnableEvents = True ' Re-enable events
End If
#excel #exceltutorial #exceltips #learning #office
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
