Assuming you are using the active cell then

ActiveCell.Offset(0, -1).Select

FYI when you ask a code question post your code or at least a snippet so
that we can see what you are up to. It makes answering a lot easier and more
precise.
--
HTH...

Jim Thomlinson


"Pa Maher" wrote:

An excell spreadsheet works as a master log of forms completed over a period
of time.
A macro opens the master log, finds the next empty cell in a column and
copies a cell of information to the cell in the other workbook. This part
works fine.
It then needs to go to the next cell on the left and copy an additional
information from the form workbook. When I use the "record a macro" it
inserts the absolute cell name (say G2) rather than a relative address (i.e.,
move one cell to the left). What statement should I use?