I have hidden some rows in my workbook. I would like to paste some data
over these hidden cells and allow the data to skip them.

For example, if I have hidden Columns B and C and I paste 1, 2, 3, 4 (all
from different cells) into a row, 1 should appear in A1, 2 should appear in
D1, 3 should appear in E1, etc. Do you know how I can skip hidden rows when
I paste data?

I am using Excel 2003.

Sincerely,

huber 57