gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,340
- Office Version
- 365
- Platform
- Windows
I have a button on the tab that runs this code. The refresh is for a table on the tab and the table starts in A5
Not sure what the error message means or how to fix the code
Code:
Sub RefreshProp()
' RefreshIHS Macro
'
Sheets("PROP_MASTER_TABLE").Select
With Sheets("PROP_MASTER_TABLE")
.Range("C1").Value = Format(Now, "mm/dd/yyyy HH:mm:ss")
End With
Range("D6").Select
Selection.ListObject.TableObject.Refresh
End Sub
Not sure what the error message means or how to fix the code