VBA: How to select multiple row in filtered data

[kabatak_02k]

hi everyone, Can anyone help me on this, im trying to create a macro that can select multiple rows and input a value on those selected row while one column is in autofilter mode..For example I want to filter Column A as "Value1" and i want to assign "TEST" to 10 rows.

thnx!

[johnjohns]

Didi not get you fully. To enter a value in all the selected cells together, press ctrl+enter after typing the value

[kabatak_02k]

what i mean is that i want to have a macro that
1. filters a category
2. inputs a name for exmple
3. inputs a number of rows to select
4. after i enter value the "name" will display on particular column like for example L2.