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    
post Aug 7 2019, 09:52 AM

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...

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