Paste date from a Named Range to previous column - VBA excel

[RAZE]

Hello,

I have named range "H1Range" (lets say H3:H16) and in each run I insert cells before the named range and copy/pastespecial H1Range data in it.
Is there a way to string the column which is in the left of Named Range?

Thank you in advance

 

[John_w]

Welcome to MrExcel forums.

Use range.Offset with a negative column offset, like this maybe:

    MsgBox Range("H1Range").Address & " " & Range("H1Range").Offset(, -1).Address

 

[RAZE]

Welcome to MrExcel forums.

Use range.Offset with a negative column offset, like this maybe:

    MsgBox Range("H1Range").Address & " " & Range("H1Range").Offset(, -1).Address

Thx works !