trying to get text to appear in text box to give direction size needs text to
wrap wrap = true doesn't wrap? setting in properties
not sure where to go next
Thanks

I am using Windows XP/Office 2003 and have the following problem
I have downloaded a file from Debra Dalgleish's Web Site www.contexture.com(File
Name:AdvFilterCity.Zip) and tried to change it to suit my needs.
But I have few problems with it...as shown in the JPG files viz. Before

I have a rather large multisheet workbook. I want to write a formula or macro
that will search the "A" column in each worksheet. If there is a number in
the column I want to copy the entire row to a different worksheet. This is
above my head and any support will be appreciated.

I want a macro that will change the default setting in the Find or Find and
Replace dialog box to search by "columns" instead of rows, and look in
"values" instead of formulas.
I'm glad all of you are there to help people like me.

I need some help with code.  I have posted what I have so far (it was
found on the net, it's not my own), but maybe I am going in the wrong
direction.  Here is what I am doing.  I have multiple excel files in
multiple directories, with more workbooks being added all the time.

Excel 2007.  I have posted this problem a couple times now.  Would anyone be
willing to let me send a copy of the workbook that is bombing in Excel 2007
to see if you can reproduce the problem and/or give me help in finding the
solution?

I know this is easy but I can't seem to figure it out, I need a macro
that will replace "NYCITY" with "NYC" if it is pasted in column 3.
Thanks,
-- Dan

I'm not the greatest at VBA so hopefully this makes sense.  I have a user
form where the user selects a from combo box 6 different text example "
Selection of Items"  then in ListBox 61 comes specifiic data in pulled from a
defined area in the work book.  Im trying to figure out ...

I want to use VBA to inert a formula into a cell.
I want to get the contents of Cell B7 on the "Balance Sheet" and insert that
into cell B$ on the current sheet.
Here is what I have but it's not working:

I'm looking for a macro that will copy data from a "master" sheet to
individual sheets based on the sheet name.  What I have is a master sheet  
containing 4 columns of data (one of which is a group id) that I manually
sort by group and then manually copy that groups information ...

I am trying to set the Selection(row"E") of a Listbox value(by clicking it) to Populate the Combobox
with Values that are in the Same Row("BH")
Private Sub ListBox1_Click()
Application.ScreenUpdating = False

I have 50 password-protected workbooks (time sheets) and a control file. Each
employee has his own file with unique password, supervisor is the only one
who can access control file and enter information that is compared to data
from individual time sheets and flags any errors. ...

I would like to have a macro that will sum noncontiguous numbers in a
column, place a numbered tickmark to the right of each number, and a
corresponding tickmark to the left of the cell containing the sum
(which would be located two cells below the last cell with a value in

I have a section of code that alters a worksheet then exports its
contents to Word. I don't want to roll back the changes, so I just
copy the worksheet, makes the changes, copy to Word, then delete the
copied worksheet.

I'm new to VB and would really appreciate any help.
What I'm trying to do is export with out any prompts or just to be
prompted once for the locations were to save the new text files. If
that's not possible create the text files in the same directory as the