paste over hidden cells

[KyWilde]

I would like to take cells from another place copy or cut them and paste them
in a section that contains a hidden column for example. When I do this
informatioin gets pasted in the hidden cells. How can I bypass these cells
and only paste in the visible ones and hence "skip" over the hidden ones?

Thanks,
Kyrsten

[prasad_bkr]

Hi,
This is recorded code of the macro, I am finding hard to replace "Range("U9:U8441").Select" and"Range("U8441").Activate", instead of this I want general code, which runs on any number of cells in this column.

Basically I want to copy the value to and paste it in the all the cells which are filtered.

It would be great if some one can help me to resolve this.

Selection.End(xlDown).Select
ActiveCell.Offset(0, 2).Activate
ActiveCell.FormulaR1C1 = "=RC[-2]"
Selection.Copy
Range(Selection, Selection.End(xlUp)).Select
Range("U9:U8441").Select
Range("U8441").Activate
ActiveSheet.Paste


Thanks
Prasad