muhittinemmi
New Member
- Joined
- Jun 20, 2023
- Messages
- 19
VBA Code:
Sub Makro3()
Range("A10:E23").Select
Selection.ClearContents
End Sub
I don't know if such a thing is possible but
Can I add the contents of cell I3 instead of e23 because row e23 is variable?
Since the number of rows is variable, cell I3 shows which row column e is in.
Example
I3= E23 or I3 = E35... etc.
I tried something like below but it didn't work
VBA Code:
Sub Makro3()
Range("A10:(Range("I3").Value)").Select
Selection.ClearContents
End Sub