Thread: Simple Moves
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Simple Moves

A,

Try...
ActiveCell.Offset(0, 1).Select

Jim Cone
San Francisco, USA


"A Waller" wrote in message
...
I am in need of osme help. I have asked previously and have gotten no
response. I have a macro which when executed wil find the first entry of a
particular product code. Once the find has done its job, I need to select
the cell to the right of the active cell. Then I will cut and paste the
information in that column to another. Could someone please tell me how to
get this move to work without choosing a "specific" cell. This macro will run
on many different files so the product code will never be in the same place
twice so I need to make sure the macro only moves to the right from the
"found" cell. Any assistance would be greatly appreciated.
--
A Waller