Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variable to call worksheets
I am writing a program that takes information a user enters (string) and uses it to create a sheet with that name. So far it has been extremely unreliable, working one minute and then not the next. The variable is marked as a string, so it "shouldn't" be looking for the worksheet by number. Oh, the information in the variable is a number. Ok, so it looks for the worksheet by name using the variable. If it can't find it, the error causes it to create a new worksheet with that name. But, the darn program keeps making "SheetX" with X representing the next sheet number (1,2,3,4,5 etc). It has actually worked a couple of times, but apparently is unstable. The variable is a public string since it is used in two or three routines. Would making it a private variable and passing it just between these routines help? My other worksheet function that activates a worksheet and unhides it works just fine using a private string. Craig Robson ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a Call to an external sheet using a variable... | Excel Worksheet Functions | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
How to keep a Variable alive after a Call to Sub Routine | Excel Discussion (Misc queries) | |||
Can I use a variable to call up another sheet in Excel? | Excel Worksheet Functions | |||
Can I use a variable to call up another sheet in Excel? | Excel Worksheet Functions |