paste range to visible cells

Can I paste a range in visible cells?

I can paste on visible cells only if I'm pasting the same value for all visible cells or if the copied region is the same row with the paste region (through cell reference), but i can't find how to paste a range.

As this is a filtered range you could do it using a macro. Run macro "FilterCopy" in uploaded xlsm file.

If you can use a formula to do this??? I don't know how to do it that way but perhaps another forum member has the know-how.

Alf

Try this:

Please Login or Register  to view this content.