erock24,
I am going to jump in on this because getting rid of the Select statements was the first thing this Forum helped me do. I had been programming for years and had always heard you need to get rid of the Select statements, but I simply could not grasp how to do it. Mudraker, from this list, solved that problem for me and I have been flying through code ever since.
Here is a small example using come coping and pasting.
The Macro Recorder gives you this
To get rid of the Select statement you simply assign your worksheet to a variable and use that to refer to your sheet (I'm not good with all the technical terms). The above becomes this
You could also do it like this
which ends up being less code, but what if you were copying this to Sheet2 and Sheet3 of different workbooks. It then becomes
This becomes very bulky especially if you are doing more complicated coding. If you go back to using the Set statements, you end up with
and this is definitely a lot easier to read. I realize this is a very simple explanation and things can be a little more complicated that I have just describe, but maybe this will give you a little understanding and help you get started.
Bookmarks