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
|