View Single Post
  #14   Report Post  
Old January 17th 09, 03:45 AM posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default "Marching ants" around copied cell

The method that Simon is describing can only be used in the workbook in
which you place the code.

The method I use (which takes more work to setup) can be used in any

Microsoft Excel MVP

"Riccol" wrote in message
Thanks, Simon. I'm going to tackle your instructions in the AM and report
back after. (Your method sounds especially good as you say it kills the
ants immediately after pasting.)


Simon Lloyd wrote:
Press and hold Alt & F11, the VBE (visual basic editor) will open, on
the left you will see a list of your worksheets and on called
ThisWorkbook, they are all code modules, double click the Thisworkbook
and paste the code i gave.

If you are ever given code for a standard module then use Alt+F11 as
before and instead of double clicking Thisworkbook, right click in that
area, choose Insert and then choose Module, then you can paste your code
in there. The best way to learn is to record a macro while you are doing
a task and then go back and take a look at the generated code, it's true
to say that you will see a lot of code that is excess to requirements
but it will give you a basic idea on how things are structured.