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: 962
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
 

Thread Tools
Display Modes


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:03 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