How to give a value to all cells in a column while it is filtered?

[prabha_friend]

Activesheet.usedrange.columns(1).cells.value = "SomeValue"

The above code enter value only for the filtered cells. How to enter a value for all the cells in the columns(1) of the Usedrange while the range is filtered?

P.S:
I don't know the filter criteria.

Kindly advise if there is a method which will temporarily suspend the filter and re-apply it without detailing the criterias again.

 

[prabha_friend]

Why no one is replying to this post ;(

 

[sanrv1f]

May be this

[COLOR=#333333]Activesheet[/COLOR].UsedRange.Columns(1).SpecialCells(xlCellTypeVisible) = "SomeValue"

 

[prabha_friend]

May be this

[COLOR=#333333]Activesheet[/COLOR].UsedRange.Columns(1).SpecialCells(xlCellTypeVisible) = "SomeValue"

No. I need something like this:
Activesheet.UsedRange.Columns(1).SpecialCells(Allcells) = "SomeValue"

 

[sanrv1f]

Did you try my suggestion?

 

[prabha_friend]

Did you try my suggestion?

Yes. Ofcourse, I tried it way long before I posted this question. Thanks to your reply. Still searching for an answer...

Can we conclude it cant be done this way?