Filtering the postings on this subject did not produce satisfying
results.
Three worksheets to start with :
1. Code Table

I am looking for something that will search col. ,
then check for a value (like the word "Building") , insert
a blank row above it.

When excel opens my csv file, the numbers in it are automatically
changed to actual numbers, when I want them displayed as text/strings.
The problem with this is that, i.e my string "00500" is changed to the
value 500 when the file is opened, and will remain as 500 when the

I am not very conversant with excel VBA programming but I have a certain
activity to complete which requires me to do that.Currently, I am stuck right
at step one.
I am trying to create a very basic resource/project planning worksheet which

I have an application where new data is pasted into a worksheet, and since
the data changes slightly each time, the data types need to be reset after
each import.  I have VBA code to reformat the data types based on what is in
the newly imported data.

I have a column with data as shown below:
     1 Jun 2007 06:00:50:000
     1 Jun 2007 06:00:55:000
     1 Jun 2007 06:01:00:000

    I am trying to figure out how to compare the data from rows across
multiple columns on different worksheets.  What I am trying to do is
output the data that is in Worksheet 1 and not in Worksheet 2 into
Worksheet 3.  Then in addition also output the data that appears in

I am pulling in data from a DB, and in one of the rows I am using a VLOOKUP
which works perfectly, however with the expectation of added growth and to
not have to worry about adding this syntax later on in the project I have
cells that have no data in them the the VLOOKUP uses, ...

I am using a call to the following function
Private Declare Function RegQueryValueEx Lib "advapi32.dll" Alias _
   "RegQueryValueExA" (ByVal hKey As Long, _
                       ByVal lpValueName As String, _

I am trying to write a macro that will find and select the first
instance of a value that the user had previously inputted into a cell
(let's say it's on sheet 1 in cell A1)   within column C of a large
data matrix,  where the matrix has been named DATA.      How can I do

I have two excel spreed sheet, sheet1 and sheet2 both has same information as
following:
IPAddress, Domain, Username, machinename
sheet1 has 900 records.

I have a user who is opening an excel sheet with some German
referenced and is getting an error message because it is referencing a
German keystroke.  The problem code is below:
Application.OnKey "{ENDE}", "aendern"

This one has to be really easy, but I can't track it down.  I know how
to remove an item from a listbox using its index value, but how do I
remove it by directly referring to the name of the item?  Example:
lbx1.RemoveItem ("DeleteThis")

By accident, there are two set of names in my workbook, workbook level and
worksheet level( existing in some worksheets) and the two set are same. how
can just change the worksheet level names into workbook level names ?
Clara

Basically, what I want to do is to prefill a cell with an automatically
calculated default value, but I want to do the calculation only until it
succeeds.
Idea: