Excel 2019 PQ shows error if source data is a range

		Microsoft Office Forums > Microsoft Excel > Excel
Excel 2019 PQ shows error if source data is a range

FAQ

Thread Tools

Display Modes

11-28-2020, 02:46 PM

Marcia

Windows 7 32bit Excel 2019 PQ shows error if source data is a range

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Quote:

Originally Posted by p45cal

However, it's probably more robust to adjust the userform code to handle a table - tables are usually easier to write code for.

The thing is I just customized a downloaded form. My code writing skill is next to nill, although I tried a search on how to disable the autofilter in a named range.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel range pasted into Word shows ##### instead of numbers	kjc	Excel	7	05-10-2020 02:15 PM
Merge same excel data source in two columns	Marcia	Mail Merge	1	07-25-2019 02:27 PM
What's new in Word 2019, Excel 2019 and Outlook 2019 and Why upgrade to Office 2019 is recommended?	einfomail	Office	0	07-25-2019 11:49 AM
Excel data linked to external source	Doug Needham	Excel Programming	1	09-15-2015 05:14 AM
How can I revise Excel data source in merge?	navysalad	Mail Merge	6	01-07-2012 06:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 AM.