Code to create named range using userform

Hi,

So I have a document where I want the user to be able to create a new named range simply by Typing in the column letter into a userform. Problem I'm having is the refersto part of defining the name.

Please Login or Register  to view this content.

So this will work if A was selected in the userform, but if B for example was chosen then I need the C1 part to change to C2.

Any help is greatly appreciated.

Thanks

Dave

Hi PFDave,

You can do what you want by replacing 'C1' in the Original Formula with a text string (such as 'QQQ') that you know will never be used in the formula. Then replace the 'QQQ' with 'C1', or 'C2' etc as per the following example macro tested and working:

Please Login or Register  to view this content.

Lewis