I'm asking you about this maybe simple matter of how to display
worksheets error messages in a cell such as #N/A or incorrect args and
others programatically from Excel VBA.
I just wrote a simple user - defined function and in case for exapmle

Hi all, I have a report and i need to insert a row at a number to be given by
the user but i need the new row if put in at the bottem of the list to take
on the format of the row above it, any help would be appreciated.

with this code
ActiveCell.SpecialCells(xlCellTypeLastCell).Column i get always the
lastcolumn of the worksheet
I need to get the last column written of each single row in a sheet

is there a way to force my user to enter only numbers in a textbox?
and in other only letters?
theres quite a few textboxe's
some thing like this perhaps?

I have a c# udf accessed as an automation add-in that needs to return dates
to Excel. I know I can't manipulate the cell's NumberFormat from within the
UDF, but is there a way to return a value that will be formatted in Excel as
a date? It seems any string value I return will ...

Hi all, this is probably so easy but it is eluding me !!
I need to make an edit button that inserts a 1 in A1 and the caption
then changes to "DONE" and when clicked again it removes the 1 from A1
and the caption then changes back to "EDIT"

Excel 2003 on Win XP
I want to display to the user of a complex UserForm a <<Please Wait>>
message while a macro with long iteration loops runs.
I've tried adding a Label with appropriate words to the UserForm, by adding

i got userfrom, multipage, lable1 on page2
how do i get the caption of that label to pick one cell down every time i
open the userform? on first open it wil show c1. second open it will show c2
thirt open c3.  untill it gets to a cell with no data and start back at c1

I am currently writing an Excel Add-In for Excel 2007 in C/C++. I want
to forward the cellcontent of an excel cell to my OLE-Object whenever
my worksheet function is called for an update.
How can I get an interface pointer to all the OLE Objects embedded in

I think I have a bizarre question to ask. I have a row of numbers in
row 1, in row 2 I have inventory, is there a way to have a conditional
format in row 1 about row 2? for example I have 12 months, column A is
Jan, B is Feb, so on. The inventories in row 2 are depleting by month,

I know I can use the split function on a string to return an array.  
Array = Split(var2)
I have 8 string variables that I want to apply the split function to and I
then want to send all these elements into 1 Master Array.  Do I still have to

I continue to have severe problems with Excel 97 SR2 crashing while
editing, compiling & running VBA.
I DO promise to upgrade soon. But meanwhile:
On relaunching Excel after its last crash, all code runs fine but the

I am looking for a one time use macro which will select and then deselect
each cell in the range G7:P300. I need this to trigger a worksheet change
macro in each of the cells. I can do this manually by selecting the cell
then clicking in the formula bar then selecting the next ...

I am looking for a one time use macro which will select and then deselect
each cell in the range G7:P300. I need this to trigger a worksheet change
macro in each of the cells. I can do this manually by selecting the cell
then clicking in the formula bar then selecting the next ...

I use the code below to force all text to be in upper case. Now I need to
ensure the the number entered in column  Q is converted to a time format.
The time is always entered in the 24 hour format (18:45 = 6:45 pm, 0645 =
6:45 am) but the often forget the  " : ". These cells are ...