Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-28-2020, 11:47 AM
p45cal's Avatar
p45cal p45cal is offline Excel 2019 PQ shows error if source data is a range Windows 10 Excel 2019 PQ shows error if source data is a range Office 2019
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2019 PQ shows error if source data is a range Excel range pasted into Word shows ##### instead of numbers kjc Excel 7 05-10-2020 02:15 PM
Excel 2019 PQ shows error if source data is a range 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 2019 PQ shows error if source data is a range Excel data linked to external source Doug Needham Excel Programming 1 09-15-2015 05:14 AM
Excel 2019 PQ shows error if source data is a range 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 04:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft