Inserting values to specified range

[Yokiboha]

I am sure this is quite simple but is escaping me

In cells S5 and S6 I have two cell references which will change each time I filter.

I wish to insert a value ("w") in this range each time the macro runs.

Can anybody help please?

 

[Joe4]

Is this what you are looking for?

Range("S5:S6")="w"

If not, you are going to need to explain your issue in a bit more detail.

 

[Yokiboha]

Is this what you are looking for?

Range("S5:S6")="w"

If not, you are going to need to explain your issue in a bit more detail.

Thank you Joe4.

I probably didn't make it clear. The cells S5 and S6 contain references to other cells, e.g. S5 contains the reference to cell Q33, S6 contains the reference to cell C53, and it is these cells in column Q that I need to fill with "w".

So in the code I need to pick up the values in the cells S5 and S6

Can it be done?

 

[Joe4]

Here is one way:

    Dim rng1 As Range, rng2 As Range
    
    Set rng1 = Range(Range("S5").Value)
    Set rng2 = Range(Range("S6").Value)
    
    rng1 = "w"
    rng2 = "w"