I have a worksheet which is 25 columns wide and I need the abilitiy to
occasionally insert a row.
When I insert the row I need all formatting brought down and the formulas in
column A, Y and Z copied down.

hello everybody, I have 2 questions:
1. my worksheets contain a macro that shows, randomly, some sentences in the
status bar. I is possible to get the text to scroll allowing for longer
texts)

Hi, I'm trying to figure out how to accomplish somehting:
I have an add-in and I would like it to chek the computer's name when
installed, if the computer's name does not match the default registered
computer's name (Leon1 in this case) then the add-in is uninstalled

I have a worksheet designed in columns. There are 0's, 1's & 2's in the
portion I am working with. I have set the 1 and 2's to coinside with a
calendar schedule. The 1 representing the start date and the 2 representing
the end date. In order to refresh my model I need the fill in ...

Google reader has been down in my area for a day.

Hi All,
 For going on 2 years I've been building a large addin, over 100 modules,
with 800 or so Subs and Functions.
 I'm not a 'professional' developer and am naive re: techie aspects of

I have a column of numbers (stock prices) that I am updating daily.  I want
to use the last value I entered in the column to calculate my losses (current
price - fixed beginning stock price).  I can get the Row number with the ROW
function, but am unsuccessful when trying to use ...

Dear All,
Thank you in advance for any help that is provided.
Following on from some of my previous posts...
I have a sheet that contains names in Column C and Dates in Column N.

I have read posts about pasting a formula into a column that already has data
by using, for example:
Range("L2:L" & Range("L65536").End(xlUp).Row).FormulaR1C1 =
"=SUM(RC[1]:RC[38]"

I'm encountering broken links after attempting to merge two xls workbooks
together...sigh.
a formula that was =Sales!P34
becomes:

I'm getting some strange results from the macro.  If I use the first
variable lngLastRow I get only 22 rows in my combo box.  If I use the
second varIABLE lngLastRow then I get 6.  The strange thing is I have
30 rows in A,B and C in my sheet.  So can you tell me what is wrong

i am actually using DsoFramer to program with Excel, i have a problem in
configuring the attributes, something like hiding the toolbar or desactive
the alert and so on.
i can open the excel file correctly, but it seems that i can only read but

I would like to protect worksheets with a password using a macro.  Recording
the macro does not seem to install the password and the worksheet can be
unprotected.  What needs to be added to the VBA code?
Thanks,

Below is part of the code I am using.  I get a "Type Mismatch" error on the
line I indicate as "<----ERROR"   Why?
Basically, this routine takes the dates for paid holidays (holdate) and
compares it to the date (on active row) + 7 days.  If holdate < wdate+7, then

[looks at box]
I'm stuck.
[/Looks at box]
I have a worksheet where the cell range has gone into double alpha