I have data in an excel spreadsheet. In one column, I have repeatative
entries. For example, the column looks like
aaaa
bbbb

I have an array of user defined types that hold info about some
columns in the spreadsheet.  I currently loop through to find the
column name I am interested in.  I would like to use the scripting
dictionary to do this since I think it would be a little faster.  I do

Similar to my last post, I want to be able to change a parameter
within a calculation.
I have tried to modify code that I used for a similar event from
before but I am stumped.

I was just running a small macro that processes a datasheet.  This is
the code, in the worksheet's module:
   With wsh
       For iRow = iSourceFirstRow To Me.UsedRange.Rows.Count

I have in sheet 1 an input date from a user.
I want to run in another sheet (let's say sheet2) based on that day the last
date of the month in order to make some calculations i need.
eg. input form user in A1 14/03/2002 - to be in B1 31/03/2002

I spotted in my travels in this forum that someone referred to 'locking the
sheets' in a workbook. I like the sound of that! So, for instance, in a
workbook with seven sheets, five could be locked leaving two open to all
users.

I am looking for something that will search col. inputed in an input box,
then check for any of the values that I have in an array, when found, insert
a blank row above it. Here is the code I am using. I am getting an error
message regarding the method can not be used with the ...

I am having trouble inserting a formula to concatenate two cells into
another cell with a comma separating them.  
Here is one of my attempts:
MainPage.Select

Can anyone tell me how to convert the date (e.g 17-09-2007) into
this format : 1 7 0 9 0 7.
Thanks in advance.
CS TANG

I have a data sheet with a header row.  DATA1
All my calculations in other sheets refer to rangeNames that start
with row2 in the DATA1 sheet.
I have found that any row can be deleted from the DATA1 sheet BUT if

I have an Excel app that calculates a 30-40 year forecast based on some
investments, interest rate etc. Basically the user enters a number of values
(20-25 values) and the main result is two charts showing the forecast.
Behind the scene there is a number of sheets with a lot of ...

I need a spreadsheet where a cell (fx."A1") shows the latest report version,
i.e. the cell needs to change the version-number from # to #+1, when you open
the report.
Does anyone know a macro which can do this ?

I have used Ron e Bruin's excellent codes to e-mail out from Excel for
sometime, but suddenly I'm getting a debug message "unable to get the
specific/cells property of the range class" on the following code and
I don't know why. The procedure has worked for weeks and no problem.

I need help.  I'm using an excel workbook as a temporary database in
unison with SPSS and generating reports.  I'm using one sheet as the
temporary database, a couple more sheets to do some formatting and
calculations, and 15 or so more sheets to generate the final outputs.

im using the following code
Sub test()
Dim x As Single, n As Integer, i As Integer, fact As Integer
n = Range("b3")