Thread: [Solved] VBA beginner
View Single Post
 
Old 09-04-2013, 11:38 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I never use Option Explicit. But there's no reason you shouldn't; you can turn it on, and include Dim statements for each variable mentioned in my code that doesn't already have one. Come to think of it, I think that's just wo.

You definitely should change the variable names to something that works for you. I like short names, so I've gotten used to meaningful abbreviations—"meaningful" in the sense that they mean something to me. But the important thing is that your program mean something to you.

But you ask for pointers to how to "do this"; you mean how to change the variable names? That's so easy that I'm doubtful it can be what you meant; you just write over them, just like editing an email. If "soFm" is nonsense to you and you want to use "SourceWSheet" instead, just write "SourceWSheet" wherever the original code uses "soFm". Or use the VBA Editor's Find/Replace function.

But as I said, that's so simple that it can't be what you were asking...?
Reply With Quote