I want to place "1" in column 8 in every row in my range named
"LegendList". How do I do this?
I tried:
LegendList(, 8) = "1"

I haven't tried this before now and i am having a little trouble.
This is what i have:
Worksheets("Sheet2").Range("C1").Value = "=SUM(C2:C5000)"
And it works ok, But i wont always know the range. I need something like:

I have a listbox that is multiselect. I want to find a way to figure out if
anything is selected, if not "do something". I wrote this which works, but I
have to think that there is an easier way.
Dim Z As Integer

OK here is what I am trying to do.
I have cells E4 through E10
That some or all Cells could contain a number 0-9, Depending on the users
needs.

Can I change the format of the comment in excel ?
I need it to be wider and shorter.
Thanks

hi,
i have the following:
Dim CurrentReportMonth As Date
CurrentReportMonth = "=DATE(YEAR(NOW()),MONTH(NOW())-1+0,1)"

I have posted this problem before and didnt get it resolved, fishing again
hoping to get lucky.
Here is my code:
Dim wsSheet As Worksheet

linked from: http://www.mrexcel.com/forum/showthread.php?t=320701
I was thinking 1 full day yesterday about this....I still couldn't think a
way out of this. I need to convert database sheet to Navision template as
shown below.(please refer to the above link for the spreadsheet)

using excel '03
I have a userform that initializes several values in both comboboxes
and textboxes.
In one of those textboxes, I would like today() (in yyyymmdd format)

Excel 2003, big spreadsheet, ~20000 rows, Col. B contains text values like
"1000", "1070", and "1120".  Users sometimes want to quickly delete all the
rows except those with one specific value in that Column.  I've tried a
couple approaches and run into (different) grief in each ...

For speed I am trying to use Replace, on a range object, to insert a string
but the replacement string is displayed as a single character whereas it
should be 2.
Say kycode = "01" this code displays it correctly as 01

I have two arrays which I want to use in order to create some
statistics. However, if I want EITHER of two things to hold true for
the array matching, then it breaks down (gives wrong value).
The following straightforward line works perfectly:

I am trying to write a script to help me determine the Mean Time Between
Repair for equipment.  I played with it all day yesterday but was not able to
figure it out.  Right now I have to enter the string manually.  The formula I
am using is "=AVERAGE(C7-C6,C6-C5,C5-C4,C4-C3 ...

I wonder if anybody can explain this?  
In developing a new program I declared a variable with indeterminate
dimension at module level (to make it available to any procedure) (e.g. Dim
variable() ).

I use this code to autofill a range.
Private Sub CommandButton1_Click()
'Macro_om_datum_te_genereren
Dim rng As Range