I'm modifying some code from Dave McRitchie to create a TOC and need
some help ...
I've set up an InputBox where users select a cell, which should become
the upper-left corner of the TOC -- this cell is called 'StartCell'.

While using another data base program, I often toggle over to an excel
spreadsheet that has frequently used blurbs in separate cells. I would
then click on the appropriate cell, press Ctrl+C to copy the contents,
and toggle back to my database and paste the blurb. I figured out that

I wrote (with mvp help, of course ;- }) a small app that I have now
installed on my work computer, which is on a network.
The IT guy set a path to drive P for me and that is where all my files
and app are located.

I have created a simple macro (recorded it). The macro involves the
creation of a Pivot Table from a NamedRange. I have created this in
Excel 2003 and it works like a dream on my computer. But it is not
working in MAC (2004). The error says "Variable Not Found".

using 2003.
   Columns("F:H").Select
   Selection.Columns.group
            will group the colums so the user can easily hide/unhide

I have a cell (D4) in Sheet 2, which is referenced to cell (D87) in
Sheet1.
Cell D4 has a dropdown (thru Data -> Validation -> list) Values are :-
Select one, 1, 2, 3, 4, 5

I have this piece of code:
newfname = EDIFormP6.WeeklyOutputp6.Value & Format(Date, "dd.mm.yyyy")
& "TESTING" & ".xls"
Open newfname For Output As #1

Suppose i have a Folder August 07
Inside there are 50 folders of Different Employees
Under Each folder i have one Excel File with the name of "Format for
the 1st Aug to 10 Aug"

I was told the following scenario involving Excel ---
-----------
The code that executes is on my computer and it applies itself to the
workbook just downloaded.

Im looking for VB that will look in column U for any instance of "abc"
and when it finds it replace the entire cell contents with nothing.
Thus for eg in cell u2 I have a value abc(if,d2-3,z,y) after the macro
runs I need to have the cell be blank. (ie delete the abc and everything

I have 2 columns (A & B) of text data, and I want to delete every row
where the same term appears in both columns. So... for each row (n),
delete the row only if An and Bn match.
Any help much appreciated.

im new to vb.net i would like to know how to insert another row for my
datatable (like doing a for loop or something)...
in this code it only inserts a single row. help pls.
very much appreciated,

What is the Shortcut for Format painter in Excel.
Like in Word
For copying the Formatting of any word you require Ctrl + shift + C
For pasting the same Formatting to any other word you require Ctrl +

I would like to know how I can take different cells (non concurrent)
and string them together in another cell with separators. The
CONCATENATE function can't do this. The end result that I am looking
for is to select a number of cells using a userform and listbox with

Can you set a password for the end user to safeguard opening an excel
file from several users?
I know you can set a password for an excel file to OPEN or MODIFY, but
does the security hold the same when the user via email or a company