Home > Could Not > Could Not Set The Rowsource Property. Unspecified Error

Could Not Set The Rowsource Property. Unspecified Error

Code: Sub ResetTable(ByRef Target_Tbl As ListObject) '--------------------------------------------------------------------------------------- ' Procedure : ResetTable ' Author : ' Date : 15/12/2015 ' Purpose : Ensure table comprises of 1 blank row '--------------------------------------------------------------------------------------- Const RoutineName I'm going to try re-creating the basic process in a separte workbook, and take it from there. I uninstalled all office versions. And i dont think i can bound the listbox because the listbox gets populated after i sort the rows based on criteria searched for in column a. Source

These are an elderly Dell laptop running Win 2000 and Office 2003 SP3 and a two-year-old generic Intel desktop (WinXP fully patched and Office 2003 SP3). This is especially helpful for the Vlookup function. Create an account Forum Main Forum Excel VBA Forum Excel 2003-07 vs 2010 VBA issues, "Could not set the RowSource property. However, if I decide to just keep running it again without the save check, I might get the run-time error instead: Run-time error '-2147467259' (80004005)': Could not get the Value property.

Microsoft. I will appreciate any inputs. David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original

Also i added a .RowSource = vbnullstring before each ResetTable(tmp_StockTbl) and the error started happening 50% less (that is a could open 2 files before the error. Probably set the memory allocation for them. I copied them to a separate folder in my desktop for back-up. 8. By rikinel in forum Excel General Replies: 4 Last Post: July 27th, 2005, 00:18 The Clear method By badger55 in forum Excel General Replies: 5 Last Post: June 17th, 2005, 18:54

I can't imagine why - though it does suggest that whatever is the source of the painfully frustrating error it isn't actually RefEdit… Jon Peltier says: Tuesday, July 7, 2009 at My VBA script updated a lot of cells each time it ran and the Change, Select and other Listbox events were going off like crazy. Register Help Forgotten Your Password? http://fracta.net/fracta/index.php/forum/2-excel-vba-forum/117-excel-2003-07-vs-2010-vba-issues-could-not-set-the-rowsource-property-unspecified-error Join Now For immediate help use Live now!

I write a lot of excel sheets for work. All rights reserved. The time now is 04:30 AM. But you can not use Additem when Rowsource has been set.

The Windows 2000 machine has Acrobat Professional 8.1 loaded, and the PDFMaker add-in (which I've heard can cause this error) works fine. https://www.experts-exchange.com/questions/22645348/Set-Column-Widths-Row-source-on-Listbox-on-open-form-2nd-update-of-settings.html Jon Peltier says: Thursday, March 18, 2010 at 4:19 pm BatGnat - Your solution works fine in a closed system. But if the workbook is closed AND excel is closed the next one doesn't error. 'Could not set the RowSource property. Dev Center Explore Why Office?

Here is my code. this contact form I've seen two or three cases in which these last few steps did not seem to work. I have the same problem and dont seem to find any answers?? However, just today an end user ran the diagnostics, and the problem was cleared up.

This can be done, of course, but different installations may store the VS components in different places. I made a short version of my application and posted on http://wikisend.com/download/439136/POM V2.0x2010short.xlsm in order to get an error you will need double click on upper listbox01 20+ times to make I wrote the following code but it gives me runtime error -2147417848(80010108) Automation error :The object invoked has disconnected from its clients. http://strobelfilms.com/could-not/could-not-set-the-selected-property-unspecified-error.html But the library is apparently not accessible.

Code, as expected didn't change anything. Page Layout / Selection Pane -> Check for potentially bad objects (there were none). Fortunately you were able to find the component and fix the problem.

I am happy to post some code, but I wouldn't know where to start.

I've gotta say it sounds like corruption though Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently The suggestions in the help files don't seem relevant so I am stuck. It's a similar problem, with the memory issue every now and then. if you can post the original file that would be great.

No time for that until next week. My bad. Thanks Aman Ask Your Own Question "unspecified Error" - Excel Excel Forum Hi, I have an excel workbook that i would like to link to various access queries in a database. Check This Out Thanks, Ajain My Excel Version: Excel 2007 Ask Your Own Question Fill A Combobox With A Named Range - Excel Excel Forum Hi, This is a very basic question, but i

When this happened, the next person I clicked on (calling the ".Clear" command) caused the error because the RowSource of the ListBox was now set. The first loop steps through each "Area" or group of contiguous cells.