Search Results

Search found 3 results on 1 pages for 'steveneedssheetnames'.

Page 1/1 | 1 

• Excel tab sheet names vs. Visual Basic sheet names

  - by SteveNeedsSheetNames

  It seems that Visual Basic can not reference sheets according to user-modified sheet names. The worksheet tabs can have their names changed, but it seems that Visual Basic still thinks of the worksheet names as Sheet1, etc., despite the workbook tab having been changed to something useful. I have this: TABname = rng.Worksheet.Name ' Excel sheet TAB name, not VSB Sheetx name. Thanks, Bill Gates. but I would like to use sheet names in Visual Basic routines. The best I could come up so far is to Select Case the Worksheet Tab vs. Visual Basic names, which doesn't make my day. Visual Basic must know the Sheet1, Sheet2, etc., names. How can I get these associated with the Excel tab names so that I don't have to maintain a look-up table which changes with each new sheet or sheet tab re-naming? Thanks in advance for your replies.

  Read the article

• Naming Optional Parameters in VSB

  - by SteveNeedsSheetNames

  In Visual Basic, I have Functions with a lot of Optional arguments. I would like to be able to pass just a few of these Optional arguments to a Function without having to use numerous commas and spaces to get to the ones I want. Somewhere I saw a way to name params such as OptVar:=val, but that does not seem to work. Just wondering if there is a way to do this. This would help readability. Thanks in advance for the replies.

  Read the article

• Visual Basic: passing arrays between Functions???

  - by SteveNeedsSheetNames

  I have a visual basic function with a ParamArray output, and I want that output to be available to another function, without having to put it on a worksheet just to pick it into that second function. Is there a way to transfer arrays between functions in visual basic? Thanks in advance for your response.

  Read the article

1