i want to clear a cell and then assign the value to it

Question

Sub Clear_Table(ct)
    Range(ct).Select
    'Range(Selection, Selection.End(xlToRight)).Select
    'Range(Selection, Selection.End(xlDown)).Select
    Selection.ClearContents
    Range(ct).Select
End Sub

Sub rite()



Clear_Table ("E10")

Range("E10").Value = "dwsds"

End Sub

getting compile error: Argument not optional (only want to clear value in a cell not the entire range and put the value in that cell. please help)

Agree with Vityata's point, but I cannot replicate your error. Perhaps you have other code. — SJR, Aug 09 '17 at 10:20

score 1 · Accepted Answer · answered Aug 09 '17 at 10:18

1

Here is something that can do the job:

Option Explicit

Sub Clear_Table(ct As Range)

    ct.ClearContents

End Sub

Sub rite()

    Clear_Table Range("E10")
    Range("E10").Value = "dwsds"

End Sub

Try to avoid Selection as much as you can. See more here - How to avoid using Select in Excel VBA

answered Aug 09 '17 at 10:18

Vityata

42,633
8
55
100

Welcome, @DaulatDaga :) Feel free to accept the answer, once you can :) – Vityata Aug 09 '17 at 10:24

i want to clear a cell and then assign the value to it

1 Answers1