How can I always open a workbook at the same worksheet?

Non-programmer question!
An associate of mine used Excel to develop an analysis program that to date
works very well. However this program also takes Excel to its limits, so new
annual data cannot be added without taking Excel down.

I have a list of names that have a space in the beginning.  For example:
" Daniel james"
" Michael james madison"
The list of names has a space before the "D" and the "M" in this example.  

Hello, I have the following code to delete blank rows within a worksheet.
'Deletes blank lines, for advance filterring
   [a1:a50000].SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Question: Is there a method to delete certain rows, if a particular cell

Hey there peoples ,
Need help. I know if you click on a excel spreadsheet and it has been
locked for editing by someone else a dialog box displays showing who
has it locked. I have a access application where I open a excel file

I need an XL Charting tip ...
I have an example of what is working for me - and an example where I
need help.
The point of the first example is to give an indication of the tip I

7 users have their own copy of the a macro.  6 of them are using their copy
and not having an issue.  The 7th one is getting incorrect results with their
own copy.
The macro (1) retrieves data from a template in the active workbook (WB1),

Can someone please suplly me with the syntax for using a named range in a
WorksheetFuntion statement
e.g
Textbox2=WorksheetFunction.Vlookup(Textbox1,NamedRange,2,False)

      Hello, I want to write a macro on excel which makes the below
job:
      I will have 2 variables let say a and b. Then , I want to copy
the rows between "row a" and "row b".  That is all. I made such an

Ok...I have used the following code to open a new workbook and go to a
spacific cell..it works fine to get to it..but is it possible to make
it open with that cell at the top?  I have a frozen column headings so
not sure how to go about it..

I have a macro that i run. The last part is to copy the data.
I then click over to an open text document and paste where the curser is,
which is at the bottom of the most recient data pasted.
Is there a way to have excel automatically, paste/export/whatever into a

Hello.  The code below scans the data in column A, and looks for cells where
the right 4 characters are 4040, 4075, 4045 or 8510.  If it does, it changes
the sign of the numbers in that row from colums D thru O.
My question is this:  Is there a way to enter 4040, 4075, 4045 and 8510 ...

I have a workbook and sheet in it.
I want to export data between the ranges B2:AS320  to another book by a
macro.
But according to my application macro should not export the empty rows.

I am working with an addin and if triggered from the menu, with no workbooks
open, how can I check to see if there are any workbooks open and if not,
prompt for one?
Thanks,

Hello.  I'm having a little trouble making a custom function that will show
the value of another cell.  Basically what I want is a Function that will get
a Cell location from a neighboring cell and then use that value to output the
answer of that cell.  I'm not sure if it makes ...