Thread
:
Excel 2019 PQ shows error if source data is a range
View Single Post
11-28-2020, 11:47 AM
p45cal
Windows 10
Office 2019
Expert
Join Date: Apr 2014
Posts: 814
PQ will work with a named range.
However, it's probably more robust to adjust the userform code to handle a table - tables are usually easier to write code for.
p45cal
View Public Profile
Send a private message to p45cal
Find all posts by p45cal