Thread: Macro Bombs Excel 2000
View Single Post
  #3  
Old 06-01-2009, 05:27 PM
jaslake jaslake is offline
Valued Forum Contributor
  
Join Date: 21 Feb 2009
Location: mineral city, ohio
MS Office Version:Excel 2007; Excel 2000
Posts: 757
jaslake is attaining expert status jaslake is attaining expert status
Re: Macro Bombs Excel 2000
Hi Leith.

I know that line of code appears to be incorrect. Please understand, I have rewritten this post several times because, apparently, your servers were (are) having a problem. Finally, the last time, I copied the text of the post to notepad so I could simply paste when I was able to finally upload the post.

That line of code got truncated into two lines as follows:

Code:
.ListFillRange = "Categories!" + Sheets

("Categories").Range(str).Address
If you delete the line break or whatever it is and make the code read

Code:
.ListFillRange = "Categories!" + Sheets("Categories").Range(str).Address

I think it will work for you. Let me know if this doesn't work for you and I will repost the code.
I should add, the macro bombs when you have selected an item in column F, Category then hit the tab key. I sure hope you can figure this out. It's been driving me nuts.

Thanks, John
Last edited by jaslake; 06-01-2009 at 06:40 PM. Reason: Add additional Information
Reply With Quote