Copying and Pasting FORMULAS from visible cells only

I have a worksheet with hidden rows, and I'd like to paste the formulas from the visible rows onto a new sheet. However, when I use "paste special-formulas", the hidden rows are still pasted into the new worksheet.

How can I remedy this problem?

Thanks,
Kate

Originally Posted by ModelerGirl

I have a worksheet with hidden rows, and I'd like to paste the formulas from the visible rows onto a new sheet. However, when I use "paste special-formulas", the hidden rows are still pasted into the new worksheet.

How can I remedy this problem?

Thanks,
Kate

Don't 'hide' the rows, use a helper column to identify which rows are needed, then Auto-Filter and select the required. Copy and paste this selection.

hth
---

Hi,

Try Ctrl + G > Special > Visible cells only

VBA Noob