Hi Everyone,
I am using a workbook with VBA programming and over 10 worksheets. Recently, it has started giving me the "This command requires at least two rows of source data" warning every time I open it. I have no idea which sheet/cells are causing this warning. Is there any simple way of finding out?
Many thanks in advance,
Rowan
Is there any code set to run when you open the file? Is it a sort code?
To check if the code exists, open the file, press Alt+F11, on the left hand side you will see ThisWorkbook. See if there is any code on the right hand side.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
This is the Workbook_Open event code:
Please Login or Register to view this content.
Last edited by arlu1201; 04-08-2013 at 07:22 AM. Reason: Code tags not quote tags.
I don't think that is the code that's causing the error.
Is there any other code in the worksheet?
Also, when you get the error is there an option to debug and does it happen when you do something specific, eg select a particular worksheet?
If posting code please use code tags, see here.
Thanks for the responses. The only code that is specific to the worksheet is:
Please Login or Register to view this content.
The warning message seems to appear regardless of what worksheet was open when I saved the workbook. I don't get any option to debug when the warning appears. I get the warning message every time I open the workbook.
Last edited by arlu1201; 04-08-2013 at 07:49 AM. Reason: Next time please use code tags for code.
Can you upload an example workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Thanks for offering to look at it. Unfortunately, it contains a lot of company data that I shouldn't be distributing and it might be tricky/time-consuming altering the data for illustrative purposes. Such a shame. Would be great if you could look at it.
Rowan
Can you tell us what's going on in the workbook?
Are there any pivot tables?
Any sorting/filtering?
Anything?
do you have any pivot tables in the workbook that refresh on open? if the data source is now blank that could cause that message
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks