vba Range().Select - Page 2

Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: vba Range().Select

  1. #11
    Board Regular Kenneth Hobson's Avatar
    Join Date
    Feb 2007
    Location
    Tecumseh, OK
    Posts
    2,695
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: vba Range().Select

     
    IF you are going with sheetnames, change .CodeName to .Name in post #9 . Change Ken to FORMAT. Change K1 to B11. Change Sheet3 to TOTALS.
    Last edited by Kenneth Hobson; Nov 15th, 2017 at 12:33 AM.

  2. #12
    New Member Dim Me as xlNoob's Avatar
    Join Date
    Nov 2017
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: vba Range().Select

    Code:
    Private Sub Workbook_SheetActivate(ByVal Sh As Object)
        If Sh.Name = "TOTALS" Then
            Sh.[C1].Activate
        ElseIf Sh.Name = "FORMAT" Then
            Sh.[B11].Activate
        ElseIf Sh.Index Mod 2 = 0 Then
            Sh.[B1].Activate
        Else
            Sh.[A1].Activate
        End If
    End Sub

  3. #13
    Board Regular
    Join Date
    Jun 2014
    Location
    Milky Way Galaxy, Earth, US, LI, NY
    Posts
    391
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: vba Range().Select

      
    Thank you Kenneth & Dim Me xlNoob !! I'm going to go with post #12 for my application.
    Last edited by Pinaceous; Nov 15th, 2017 at 01:25 AM.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com