Thread: Do's and Don'ts So Others Won't

Here is more for the do or don't thread.
While in VB editor, there is the option to insert a new module or, the actual worksheet can have code written into it. I guess my question is, when is it appropriate to insert code into the worksheet? I mostly use modules but I have inserted code into worksheets when I am designing a worksheet. Is there a do or don't for code in worksheets compared to modules? Some insight is appreciated as always.

As a general rule, event code (for the sheet and its objects) goes in a sheet (or workbook) module. Everything else goes in a normal module. There are different schools of thought, but they're wrong.

Originally Posted by romperstomper

There are different schools of thought, but they're wrong.

Thanks romperstomper, lol, I'll take your word as gospel on the matter then.

@romper, nice carving by the way for your avatar. Did you carve it? It is a pumpkin right?

Yes, and yes. Thank you - my daughter wasn't impressed by any of them!

my daughter wasn't impressed

Appreciation of art will not develop before the age of 3.

Originally Posted by davegugg

Alright, pop-quiz hot shots. Do you re-use variables? If you have multiple (non-nested) loops, do you re-use i for integer?
What if you use a string to find a workbook name using the application.getopenfilename dialog box. Would you redefine the string after opening the workbook to get rid of the path in the name?

I still use J as a loop variable where the loop is just a counter, if I actually do anything with the loop variable a more meaningful name is appropriate!!

If you just wanted the total of hours, add column D as a helper to your first sheet :-

=Month(a1)

then you can total for each month with :-

=SUMIF(Sheet1!$D$2:$D$13,9,Sheet1!$C$2:$C$13)-SUMIF(Sheet1!$D$2:$D$13,9,Sheet1!$B$2:$B$13)

Pivot table is the best way to go!!!!!!

and that answers what question squig?

oops, blush! erm it answered on question somewhere!

Ok if the post below answers your question then YEY, otherwise oops!

I think you'll find the answer is 42

Dom

and the question then must be "What is your age?!"

I was very disappointed in the final book of that series. Sighhhh

A lot was made previously about using GoTo, but how do you handle errors without using Goto? Or is error handling the one exception?