Create Worksheets named after cells in a range

[Excel-VBA]

Hi All,

I have a range of cells, let's say B2:B6 with various names.

Now I would like to create worksheets for each of those names.

I have written the following, but it gives an error on line "sheets.name (cell)" with the error: "Compile error: method or data not found".

Additionally, besides giving a name, I would like to add data to each sheet. But I can just add a command for that after this is fixed.

Thank you

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[Excel-VBA]

Hi Fluf,

Your code works, thank you.

However, I have difficulty reading this.

How about

Please Login or Register  to view this content.

Evaluate is used to shorten code, isref to check for a reference.. So, you check to see if it is purely a value and not a reference?

Thank you

[Excel-VBA]

Try:

Please Login or Register  to view this content.

Thank you Mumps1, for you also a question.. Why the set ws = nothing?

I understand the

Please Login or Register  to view this content.

But the rest seems vague to me.

Hope you can explain a bit, thank you!

[Fluff13]

The Evaluate line is there to check that the sheet does not already exists.
If the sheet exists the isref function will return true & so it will not try to create it again.

[Excel-VBA]

The Evaluate line is there to check that the sheet does not already exists.
If the sheet exists the isref function will return true & so it will not try to create it again.

Thank you for the clarification. Reputation is added

[Fluff13]

Glad to help & thanks for the feedback