-
OK. As for speed, I got it. The best rule of thumb is to have a readable code. It won't do much to reduce If loops on 1 line, apart from making the code less readable.
Otherwise, gmaxey, I certainly agree that Selection is useful (otherwise it wouldn't exist in VBA), but as I learned a brand new world (to me) - i.e. Range - I thought I'd better try my best to use it over Selection!
Bascially, commenting is definitely a highly recommended practice. As for readability. Then, of course, each one of us has his own coding style...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules