Hi
If i use
For Each b In rng3
      combo_timer.AddItem b.Text

Hi i have a macro that copies a worksheet and saves in my documents. My
guestion is there a way to save the file with the current date each time.
thanks

As I have no VBA experience, please would it be possible for someone to help
me with a problem I cannot easily solve. I would be grateful if someone
could point me in the right direction with some code.
I have the following data sheet :  Four columns A,B,C,D - Not limited to 3

Hi, I'm stuck on how to calculate sum within hierarchy. Below is what
I'd like to archive. How can I create a macro that in the end will
WRITE A FORMULA into the cells for every level? For example, at Level
0, the formula is sum all Level1, at level1 = sum all level2 and so on.

1) Does the Excel has a COM component that will behave as Statistical library?
2) Can this COM be used in Visual Basic 6.0 ?
3) Can it calculate the statistical functions and return the result, if data
is passed thru VB 6.0 ?

I have a hyperlink (email address) in a user form, but what I would
like to do is when the link is clicked, the  file to get attached to an
email.
Here is the code I presently have, where by clicking will open an email

I need a formula for Excel to calculate the cumulative interest paid on
a loan and a formula to calculate the cumulative principal as well.
I am exporting the data generated through a dynamic link to an Excel
spreadsheet. Regrettably, the program I am using doesn't support either

If I wanted to set the print area to just print
Sheets("Sheet1").Range("A1":"E9")
rather than the whole sheet, how do I do this from a macro button. I
know that

I need copy a cell into a range of cells in another column, where the
range is determined by the height of another column (row value of the
last non-blank character)
The following code copies the contents of cell D1 into the range

Code:
Worksheets ("Master").Range ("Q:R").Copy Worksheets("Sjournal").Range
("U:V")
What's the best code to copy just "Q" to "R"

I would like to delete all files in a folder where the file name starts
with a number.  So it would delete 33.xls but not delete Mike.xls
The file in question is C:\Temp
TIA! - Mike

This is the routine I used to concatenate 2 columns.  How would I
concatenate 3 adjacent columns?
Thanks,
Jim

I have a list box that I populate using the following code:
   Load Userform1
   Userform1.varinclude.Clear
   For i = 1 To NV

I have two separate worksheets.  Worksheet 1 contains a list of position
#s (personnel).  Worksheet 2 contains a list of position #s (Column A)
with individual names (Column B).  My task is to compare position #s in
the two worksheets and when they match, copy and paste the ...

Just another rookie question, but when I send my spreadsheet(macro) to my
associates, it gets blocked because it is not signed.  ???? I'm not sure what
this means, or how I go about signing the project, so they can use my data.  
Any ideas. . .again, I realize this is rookie ...