|Posted: August 28, 2006, 6:23 pm - IP Logged|
Neat little trick that may help you out in what you are trying to accomplish.
While in Excel, do an activity that could benefit you if it was a Macro (aka VB code). Simply record the steps with the Macro Recorder turned on.
Then when you are done, end the record session. Next, click Edit the Macro and take a peek at what it gives you.
Keep in mind, it will literally record each and every step and keystroke you make.
One other note, understand how to use the coordinate system instead of hard coding the cells. The coordinate system uses the x,y method and refers to cell A1 as 1,1
This also makes it easy to do loops and for/next statements.
Also, do a bit of research on the Select Case command. It works better then IF/THEN statements and has a higher limit of choices. I think If/Then stops at 7 whereas SelectCase can go into the hundreds. Just remember, keep the values in numerical order (smallest to largest).
Now, I am no expert at programming or VB, I know just enough to get me out of binds and to keep me in trouble. Another cool source of info for VB and Excel is http://www.mrexcel.com/
Although, I think they offer up a few services, the main forum is free to sign up and ask for help on. I have gotten several bits of usuable code from there.
So Good Luck and have fun.