DON'T PASTE IN HIDDEN COLUMNS

[SHERRY]

IS THERE A WAY THAT I CAN HIDE VARIOUS COLUMNS ON MY
WORKSHEET AND PASTE SOMETHING FROM ANOTHER WORKSHEET ONTO
ONLY THE UNHIDDEN COLUMNS.

THANKS SHERRY

 

[Poh]

Hi
Try this
Select the range (inclusive of hidden column), click Edit

Goto > Special > Visible cells only (system will select

those cells that are not hidden). Then, carry out the
usual copy and paste action.