Using range to fill in cell values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this bit of code that I use to fill in sheet names for a large report.
I am trying to conserve space. Also, it doesn't work. I get a 438 runtime
error. I need to know how to fix this so the object does work.

'Rename Sheets
i = 1
For Each c In SheetNames
Sheets(i).Names = c.Value
i = i + 1
If i = 19 Then Exit For
Next c

Regards,
N
 
It is a set range (object) that I created. It is bound early and contains
string variables.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conflict 8
Advanced Filter Error - I cannot spot my Error 3
Value from one sheet paste under same value on other sheet. 7
Odd Export as PDF problem - Killing me. 6
Runtime error 1004 when trying to insert formula in cells 11
Add sheet and name it unless it already exists 12
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Name the range AFTER copied to new sheet 6

Back
Top