Defining a Named Range using Offset

Hi,

Does anyone know how I can define a named range using Offset in Vba?
I recorded the following macro to get an idea of what I needed but I'm unsure how to adapt it for Offset

Please Login or Register  to view this content.

I tried a few things but have been unable to get any variation to work. I need it to give a selected range a name and the name needs to be the value of a textbox on a userform.

For example

Please Login or Register  to view this content.

Thanks in advance

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Originally Posted by JBeaucaire

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Hi Jerry,

Thanks for the response. The 1st solution didn't work but the 2nd worked a treat.

Kind regards