Below is a macro to move any cells that contain the word Total in
Column A to Column B.
But how would I move the word total from column B to column A? Thanks
Sub testing()

How do i code this if formual?
=SUMIF(TOEPIEXP!F:F,"=1",TOEPIEXP!P:P)

Does anyone know about this and why it's happening? I used to be able
to bypass any Auto_Open (or Worksheet_Open) code by holding down Shift
while I open the spreadsheet... this is no longer working. My code runs
anyway, which makes it very difficult to modify/test code that's in an

What is the code I need to write in order to:
1. Print the first page of an active worksheet?
2. Print a selected range (A1:B5 for example) of an active worksheet?
Thanks.

I am trying to perform a single event to multiple ranges but for some
reason I can't get the macro to work if I write it on multiple lines.
If, for example, I write:
Sub Clear_Ranges()

To all,
I have a worksheet full of numbers ( DATA1 ), I want a macro to be able
to go throught this worksheet, and delete all values that are greater
than or equal to 2000. Any ideas?

To all,
I have this code that deletes all but the active worksheets. This
deletes the sheets fine, but then returns the error:
Method 'Delete' of Object_ Worksheets Failed

Ok, when doing something like this:
-----------------------------------------------
Sub OrderSheets()
   For i = 5 To Worksheets.Count

I have a collection object and it seems limited to 256 items.
How is it possible to increase this limit ?
thanks a lot,
Al.

I start a VBA macro in Excel. This macro is running several minutes.
During that time I open e.g. the Internet Explorer.
When the VBA macro has finished it shows a MsgBox. Unfortunately I
don't see this message box because Excel is not the avtive application

 Recently, my company uses Excel routing function to share documents. Some
users want to check their Excel worksheet contents before route the Excel
files to other. i.e. When he press "Route" button to route the Excel file,
Excel will check some specific cell contents, if ...

All,
I have a combo box on a worksheet, which is made visible if a
particular cell is selected, I added the dropdown method to display the
combo box with the list automatically visible should someone select

   Looking at the object library documentation for Excel it suggests that I
would be able to use EMF as an export format for a chart object in a
spreadsheet.  This makes sense to me as surely its in EMF format anyway,
unfortunately it seems to fail...

Can any one help?!
I am trying to say:
If cell [blah,blah] = Jack or Paddy then cell [blah, blah] should =
Jazz

To all,
I have date and time data in two seperate columns in a worksheet called
' ImportedRawData '. In column A is the date and in Column B is the
time: