Tried posting this under the services forum but it would not let me in.
I wish to hire someone to help me with a new excel project. Need
someone who can program and write scripts. Sorry to be so general but
will expand when I contact the right person.

hi all,
im a lil new to excel automation so forgive me if this is a little easy
for you all.
i have been using an advanced filter which requires the following

Hello from Steved
Please how do I insert a row shift the cursor down one cell copy and then
paste to the above.  I got about 10,000 rows to do. Thankyou.
Sub Broken()

I am having an issue with a For Next loop where the current loop value
seems to be incrementing before getting to "Next".
Basically I want to loop through a number of periods (months) picking
up any rows that have a date that falls within the current period. The

I have a named range "Eng1" (B1:B5) and if the user enters data int
all 5 cells I want the range to expand to include (insert) a new row.
want the new row to be B6. In other words I want the bottom cell i
range "Eng1" to always be blank. It will start out 5 rows deep an

let me try to explain my problem.
I have to xls-files : book1.xls and book2.xls
I also have 2 versions of an xla = c:\temp\ver1\funcs.xla and
c:\temp\ver2\funcs.xla

I have a data sheet, which I had assigned to a worksheet variable, shData
I used code
shData.move after:=shADI
where shADI is another worksheet variable.

I have an option button which provides an Input Box once selected.
What I would like to know if there is some way I can refer to the
information provided to the input box in another Sub.
ie

Hi Tom,
Thank you for your advice. I am not sure what is happening or if I placed
your code correctly but the form comes up but the listbox is no longer filled
when the user makes a choice from the combo box (cmbgrower) The following

is there a formula to convert 5.08 into years/months?  I know 5 = 5 years,
but can't figure out how to determine what .08 is.  Thanks

Does any one know how to capture excel API events like copy/paste, cut/paste
events through c# code?

I have a workbook that was created using an older file as the starting point.
Somewhere along the way information was deleting leaving behind defined
names and macros.
I have tried to delete these old macros but the delete button is grayed out

I would like to fill a combobox (Rowsource) with data that are used in for
instance the XValues or Values of a Seriescollection of a graph.
"ActiveChart.SeriesCollection(1).Values" does not give the right type (I was
hoping for a string type of info like "Sheet1.Range(a1:a10)").

I have tried to use CurrentRegion to define a range, and it doesn't work in
the workbook, but works in the editor.  I have used it on a function, and the
function doesn't get the right region when called from the worksheet, but it
does from the Inmediate window.

I have code to select worksheets using an inputbox box. I am using the code
below, but what is happening when someone puts in a name for a sheet that
can't be matched is it returns the first sheetname i.e. SHEET 1. What I would
like it to do is to return an error message. The ...