JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 558
- Office Version
- 365
- Platform
- Windows
Hi
I have a very simple user form with a command button it. The code behind the userform and button is this. Maybe I am missing something very obvious, but i don't see why this would throw an error 91.
all direction given is most appreciated
I have a very simple user form with a command button it. The code behind the userform and button is this. Maybe I am missing something very obvious, but i don't see why this would throw an error 91.
all direction given is most appreciated
VBA Code:
Private Sub UserForm_Initialize()
With frmTestData
.StartUpPosition = 0
.Left = Application.Left + (2.5 * .Width)
.Top = Application.Top + (0.5 * Application.Height) - (0.75 * .Height)
.Show
End With
End Sub
Private Sub btn7columns_Click()
With Sheet26
.Range("A2:A250").Value = .Range("G2:G251").Value
End With
Unload frmTestData
End Sub