I have this macro whitch copy antire row
from one wbook to another If a value is

PART 1 OF TOPIC !

I have two workbooks that I have open.  WorkBook A has data in it.  WorkBook
B is blank.  
If I use this code, I can get the date from WorkBook A
       Range("A2").Activate

Can anyone help me write a macro that tells excel to delete any text that is
between brackets? IE - [[xx]] (delete the xx when macro is run)? I need to
make 2 versions of a spreadsheet - one with text with brackets and one where
the brackets remain but the text is deleted... ...

I have a file that I want the user to click an insert button and not
be able to insert rows.  I have protected the sheet, except for the
area they can enter data into and have created another Sort button.
My code keeps errors at the sort stage.  Any help is appreciated.

I'm trying to make a fuction to change cell color when value change,
for example, I call this function is "chcl", when I use
"=if(A1>5,chcl(A1,red),0)" then if value in A1>5, color of active cell
change to red else has no change. Please help me to solve this

Attached is the visual basic coding for the macro which creates a journal
entry for upload. I need to sort this in ascending order because descending
order is causing an intercompany nightmare (as we do not consolidate the
higher numbered companies).  How can I change the code to ...

Has anyone who has to work with Macs alot in their environment ever
seen strange occurances when saving Excel files, created on the Mac in
mac Office, to a Windows file server.
Strange occurances would be the file being corrupted when saved,

In a project which was originally speced to require Excel 2003 or
later, the beta customers have requested, and management has agreed,
to try to get it to work in Excel 2002 and 2000.
I'm doing a lot with a ActiveX Combobox on a worksheet -- moving it

I have a file that I want the user to click an insert button and not
be able to insert rows.  I have protected the sheet, except for the
area they can enter data into and have created another Sort button.
My code keeps errors at the sort stage.  Any help is appreciated.

So far I have a sheet and I Have a Form. I want to hide the sheet so that  
soon as I open my file, all I want to see if the form. Is this possible ??
Thanks all......

My print macro works if I run it from the sheet that I want to print, but if
I am on another sheet, it appears to do nothing. I actually want a button on
another sheet and want to print the sheet in question, without having to
select that sheet first. My macro is below:

Thansk for your help.
My group here administers a shared workbook that calculates a whole
bunch of things for a portfolio of assets. The core of the infromation
is a log of all activity in the protfolio (Buys, Sales, Repayments,

I want the user to click on a button in a spreadsheet, select a workbook and
open it.  In order to do this, I created a dialogue to get the file name and
path.  What I would like is for the dialogue box to open to a designated
location.  To do this I tried the following code:

I'm actually experiencing 2 problems with my project for Excel in
VS2005.
I've MS Office 2003 and MS Office 2007 installed on my computer. When
I create an Excel application in VS2005, the designer shows me Excel

Hi, I have a question:
I'm busy with a website which publish every day charts with the
results of something that I have measured. I need Excel for the
transformation of rough data into charts who are easy to interpretate.