February 8, 2006
Calling all VBA geeks
Ok, I need some VBA expertise here. I'm writing a bunch of macros inside Microsoft Excel, and I came across an unfortunate catch. Let's say you start a subroutine like this:Sub XYZ()
Dim abc As Integer
abc = WorksheetFunction.Lookup(yada, yada, yada)
Now, if you make the next line
Dim lookup As Variant...then you will "poison" your namespace such that the previous line will immediately change to
abc = WorksheetFunction.lookup(yada, yada, yada)Deleting the "Dim lookup..." line doesn't fix the problem -- it appears to be a permanent change. The only fix I can find is to create an entirely new workbook and manually copy over all my modules. Anybody know how to, in essence, repair my namespace?
Posted by Jeffrey at February 8, 2006 7:11 PM
What is a TrackBack? Learn more here. TrackBack URL for this entry:
http://www.geekable.com/cgi-bin/mt-tb.cgi/1061
Listed below are links to the 0 weblogs that reference 'Calling all VBA geeks' from Geekable.com.
http://www.geekable.com/cgi-bin/mt-tb.cgi/1061
Listed below are links to the 0 weblogs that reference 'Calling all VBA geeks' from Geekable.com.

