daniels012
Well-known Member
- Joined
- Jan 13, 2005
- Messages
- 5,219
I have created code to enter data from the Active cell. However, I would like to edit it so that the user can only make this work if they are on Rows 6 through Row 29.
Here is the code:
How can I do a check before the code is executed to be sure the users active cell is in Rows 6-29.
let me know if I need to provide more info!!
Thank you,
Michael
Here is the code:
Code:
Sub DropDown7_Change()
'Right here I want: If ActiveCell. is in Row 6-29 Then
Application.ActiveCell.Value = Range("D3").Value
Application.ActiveCell.Offset(, 1).Value = Range("F3").Value
Else Msg = "Move into the proper rows"
End Sub
How can I do a check before the code is executed to be sure the users active cell is in Rows 6-29.
let me know if I need to provide more info!!
Thank you,
Michael