Defining a named range

Hi, I'm trying to define a named range and so have taken the easy way out and recorded the macro. However, when I use the piece of code that's recorded, it doesn't work. My code is fairly straight forward and I'm looking to set column G as range on Sheet1

Please Login or Register  to view this content.

Can anyone help please?

Many thanks

M

Try

Formula:

Please Login or Register  to view this content.

Many thanks Bob. The C7 was actually column 7 (G) but it all works fine now. Many thanks for your help

M

So it was, I missed the R1C1