Range Error naming worksheet

Hi guys,

I'm creating a new worksheets with a chart for each row of data. I need each worksheet to be given the name of the data in columns B and C (ie. surname and forename); however I'm getting a "Method Range Error"

Here's a bit of the code that works for just one column (ie. column B)

Please Login or Register  to view this content.

I know it's something really simple and you'll have to excuse my ignorance .. I'm pretty new to Excel.

Thank you

Welcome to the forum, technik.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

If you add a new sheet, the sheet is blank (unless you have a default sheet template with data in it). Therefore column B is blank, and a null string is not a valid worksheet name.

Sorry if you've already answered my question in your reply, but I didn't really get it.

I haven't, I misread your code, sorry.

Please Login or Register  to view this content.