About deleting variable rows

[muhittinemmi]

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

Sub Makro3()
Range("A10:(Range("I3").Value)").Select
Selection.ClearContents
End Sub

 

[Akuini]

Try:

Sub Makro3()
Range("A10:" & Range("I3").Value).ClearContents
End Sub

 

[muhittinemmi]

Thanks code works fine problem solved

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.

 

[muhittinemmi]

Try:

Sub Makro3()
Range("A10:" & Range("I3").Value).ClearContents
End Sub

It's not related to the topic, but if I want to copy this field, how should I change the code?
I added .copy instead of .ClearContents but couldn't get it to work

 

[Akuini]

I added .copy instead of .ClearContents but couldn't get it to work

You mean like this:

Range("A10:" & Range("I3").Value).Copy

then it should work. Can you explain 'but couldn't get it to work'?

 

[muhittinemmi]

It gives the following error

Runtime-time error '1004'
Method 'Range' of object'_global' failed

 

[Akuini]

It gives the following error

Runtime-time error '1004'
Method 'Range' of object'_global' failed

and it stopped at this line?

Range("A10:" & Range("I3").Value).Copy

Not sure why, can you post the whole code?
What is Range("I3").Value?

 

[muhittinemmi]

The problem is due to the value in I3.

Thanks for information.

Sorry for taking your time for such a simple thing.