UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Compile Error In Vba - In Valid Use Of Me Keyword, Any Version    
 
   
bakersburg9
post Aug 7 2019, 09:52 AM
Post#1



Posts: 5,573
Joined: 2-November 04
From: Downey, CA


Can't understand why I'm getting this message - I want to rename the worksheets with the value in A1 - actually, I don't really need it to do all the worksheets, like my code is written for - I just really need it to do the CURRENT worksheet - but I'm just testing it out...

CODE
Sub goToNextWorksheetTEST()
    
Dim WsheetTEST As Worksheet
         On Error Resume Next
             For Each WsheetTEST In Me.Worksheets
             WsheetTEST.Name = WsheetTEST.Range("A1")
             Next WsheetTEST
         On Error GoTo 0
        
  End Sub
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    19th October 2019 - 04:34 AM