declared variables

I've been using VBA (and this message board) on and off for years. The majority of the time I find I don't need to post because somebody has already asked and answered the question; but this time I'm truly stumped. I tend to modularize the majority of my code to make troubleshooting easy and...

Hey Y'all, So I am making a loop to check a list in one workbook against a list in another workbook, but when I try to run the code, it only accepts the declaration for the workbook that is active and gives a runtime 9 "object out of range" when it gets to the second workbook, and if I am on...

Hi there, I am having a simple issue, I am not being able to call a sub that is in another userform. On userform1 I have this sub I use to load information to the userform. (It was before declared as Private, but I thought if I declared it as Public It would solve the problem) Public Sub...