Selection to the Left (plus/minus 1)

[default_name]

I am having a similar struggle as the OP in this thread, except in mine I am trying to go to to the left, minus 1 (or would it be plus 1?). I basically just want to start at FM8 and select all the way left, then move the selection to the right one column.

I recorded the macro to try and get this to work, but it isnt very intuitive at all.

Here's what I have:

    Range("FM8").Select   'Starts at cell FM8
    Range(Selection, Selection.End(xlToLeft)).Select 'Selects all of the blank cells to the left, until it hits a cell with a value. It selected all the cells from FM8 to the left (in this case it found a value at EF8)
    Range("EG8:FM8").Select 'I want to shift the selection one column to the right (FM8 all the way left to EG8)

I would like it to look something like:

    Range("FM8").Select   'Starts at cell FM8
    Range(Selection, Selection.End(xlToLeft)).Select-1 'Selects all of the blank cells to the left, until it hits a cell with a value. Then shifts the selection -1 (or would it be +1) so that the cell with the value isnt selected

But that doesnt work.
Thanks in advance for your help!
(apologies for posting this in an older thread)

 

[VBE313]

Range(Selection, Selection.End(xlToLeft)).Offset(0, -1).Select

 

[Fluff]

How about

Range("FM8", Range("FM8").End(xlToLeft).Offset(, 1)).Select

Although there is very rarely any need to select cells

 

[default_name]

You guys are so amazing! Seriously!
Thank you!

 

[Fluff]

Be aware both codes do different things