Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox for Worksheet name - problem
I'm using:
WkSheetName = Application.InputBox("Please type a name for" & _ " this Worksheet ... in CAPITALS") 'update the user Application.StatusBar = ".....now processing... " & WkSheetName ActiveSheet.Name = WkSheetName User's are reporting an occasional error (1004: While renaming you entered an illegal character..etc) on the line: ActiveSheet.Name = WkSheetName When I check, I can see that somehow WkSheetName has the value : WkSheetName : "EXTERNAL+$1:$1WORKS" : String in the Locals window, as opposed to the correct value of: EXTERNAL WORKS. How might this have occured, and can I prevent it please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.586 / Virus Database: 371 - Release Date: 12/02/2004 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox for Worksheet name - problem
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuart" wrote in message ... I'm using: WkSheetName = Application.InputBox("Please type a name for" & _ " this Worksheet ... in CAPITALS") 'update the user Application.StatusBar = ".....now processing... " & WkSheetName ActiveSheet.Name = WkSheetName User's are reporting an occasional error (1004: While renaming you entered an illegal character..etc) on the line: ActiveSheet.Name = WkSheetName When I check, I can see that somehow WkSheetName has the value : WkSheetName : "EXTERNAL+$1:$1WORKS" : String in the Locals window, as opposed to the correct value of: EXTERNAL WORKS. How might this have occured, and can I prevent it please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.586 / Virus Database: 371 - Release Date: 12/02/2004 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox for Worksheet name - problem
Stuart,
You are using Application.Inputbox, and this allows more flexibility in inputting data. Unfortunately, this can include any cells selected, which is your problem. Use this instead WkSheetName = InputBox("Please type a name for" & _ " this Worksheet ... in CAPITALS") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuart" wrote in message ... I'm using: WkSheetName = Application.InputBox("Please type a name for" & _ " this Worksheet ... in CAPITALS") 'update the user Application.StatusBar = ".....now processing... " & WkSheetName ActiveSheet.Name = WkSheetName User's are reporting an occasional error (1004: While renaming you entered an illegal character..etc) on the line: ActiveSheet.Name = WkSheetName When I check, I can see that somehow WkSheetName has the value : WkSheetName : "EXTERNAL+$1:$1WORKS" : String in the Locals window, as opposed to the correct value of: EXTERNAL WORKS. How might this have occured, and can I prevent it please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.586 / Virus Database: 371 - Release Date: 12/02/2004 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox for Worksheet name - problem
Thanks.
Seems hitting the spacebar with the shift key depressed gives an unexpected bonus (namely the activecell address). Another thing I didn't know! Regards. "Bob Phillips" wrote in message ... Stuart, You are using Application.Inputbox, and this allows more flexibility in inputting data. Unfortunately, this can include any cells selected, which is your problem. Use this instead WkSheetName = InputBox("Please type a name for" & _ " this Worksheet ... in CAPITALS") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuart" wrote in message ... I'm using: WkSheetName = Application.InputBox("Please type a name for" & _ " this Worksheet ... in CAPITALS") 'update the user Application.StatusBar = ".....now processing... " & WkSheetName ActiveSheet.Name = WkSheetName User's are reporting an occasional error (1004: While renaming you entered an illegal character..etc) on the line: ActiveSheet.Name = WkSheetName When I check, I can see that somehow WkSheetName has the value : WkSheetName : "EXTERNAL+$1:$1WORKS" : String in the Locals window, as opposed to the correct value of: EXTERNAL WORKS. How might this have occured, and can I prevent it please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.586 / Virus Database: 371 - Release Date: 12/02/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.586 / Virus Database: 371 - Release Date: 12/02/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox | Excel Discussion (Misc queries) | |||
Inputbox with VBA | Excel Discussion (Misc queries) | |||
InputBox Method Logic Problem | Excel Programming | |||
inputbox | Excel Programming | |||
inputbox | Excel Programming |