| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using range to fill in cell values
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 -- Nicole BI Programmer/Analyst Consultant |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using range to fill in cell values
Where are you getting SheetNames, and what is it?
-- -John Please rate when your question is answered to help us and others know what is helpful. "Nicole" wrote: 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 -- Nicole BI Programmer/Analyst Consultant |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using range to fill in cell values
-- Nicole BI Programmer/Analyst Consultant "John Bundy" wrote: Where are you getting SheetNames, and what is it? -- -John Please rate when your question is answered to help us and others know what is helpful. "Nicole" wrote: 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 -- Nicole BI Programmer/Analyst Consultant |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using range to fill in cell values
It is a set range (object) that I created. It is bound early and contains
string variables. -- Nicole BI Programmer/Analyst Consultant "John Bundy" wrote: Where are you getting SheetNames, and what is it? -- -John Please rate when your question is answered to help us and others know what is helpful. "Nicole" wrote: 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 -- Nicole BI Programmer/Analyst Consultant |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can RGB fill color be automated based on 3 cell values? | Excel Discussion (Misc queries) | |||
| Copy/Fill cell values in a column | Excel Worksheet Functions | |||
| fill cells values with range values | Excel Programming | |||
| fill in data range knowing start and end values | Excel Worksheet Functions | |||
| Fill in Combo Box with range values???? | Excel Programming | |||
Hybrid Mode
