Results 1 to 6 of 6

How to ignore the zeros in activating the sheet by name

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    How to ignore the zeros in activating the sheet by name

    Hi All,
    I have a code to activating Sheet based on value in cell A1
    On Error Resume Next
    If Not Intersect(Target, Range("A1")) Is Nothing Then
        Sheets(Range("A1").Value).Activate
    End If
    On Error GoTo 0
    The name of sheets e.g:
    -000234
    -455789
    -000777
    I want if we typed "234" still go to sheet "000234".... if type "777" still go to sheet "000777"
    is it possible to do with VBA code..? is there another way
    *the cell format in A1 is text..

    Thanks in advance
    Last edited by herukuncahyono; 07-11-2013 at 08:57 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1