Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The following macro works fine in Excel 2003 but generates a compiler error
on 2007. Any ideas or direction? Sub WhoRang() Dim ButtonLabel As String Dim First6chars As String Dim RowNum As String ButtonLabel = Application.Caller ' 2007 compiler error occurs here First6chars = Left(ActiveSheet.Shapes(ButtonLabel).TextFrame.Cha racters.Text, 6) RowNum = Range("N1:N32").Find(What:=First6chars).Row Application.GoTo Range(Range("O" & RowNum).Value) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compiler Error - Not an Appropriate Name | Excel Discussion (Misc queries) | |||
Compiler Error | Excel Discussion (Misc queries) | |||
Closing Excel user form generates error | Excel Discussion (Misc queries) | |||
cutting and pasting rows from one sheet to another generates error | Excel Discussion (Misc queries) | |||
Excel Analysis Add-in EOMONTH generates #NAME? error | Excel Worksheet Functions |