Not pasting in hidden cells?

[Ste_Moore01]

Hi guys,

I have a sheet where there are hidden rows.
The example below shows my sheet but with the hidden rows highlighted in yellow.

ELECTRICAL PRICEPACK MAKER.xls
	A	B	C	D	E	F	G
10	STOCK REFERENCE		PRICE	DISC.	PER (FOR TRUNKING TYPE NO. OF METRES)	TOTAL	DISC. OFF TRADE
11	1G/DRY-47				4	0	100
12	1G/DRY-BLU				100	0	100
13	1S/20				20	0	100
14	1S/20B				20	0	100
15	1S/25				20	0	100
16	1S/25B				20	0	100
17	2G/DRY-47				4	0	100
18	2G/DRY-BLU				100	0	100
19	2S/20				20	0	100
20	2S/20B				20	0	100
21	2S/25				10	0	100
22	2S/25B				10	0	100
23	3S/20				20	0	100
24	3S/20B				20	0	100
25	3S/25				10	0	100
DETAILS ENTRY

Sometimes I have had to change the formula in column F and I was wondering, rather than having to copy and paste it into each individual cell in the table, is there a way of highlighting the whole column and pasting it without changing the hidden/yellow rows?

It's not so much as an urgent problem as it is a query.

Any help would be much appreciated.

Thanks!

 

[SteveO59L]

Use the entirerow.hidden=true property as the condition of an if statement

 

[Ste_Moore01]

I'm sorry, I think I didn't make myself clear enough.

I'm hoping to copy the formula from F11 (for example) and paste it in all the cell in column F without pasting it in the yellow rows which are normally hidden. I was wondering if there was a way of doing this.

Also, I'm quite new to the macro code thing so I was hoping for a little more in-depth instructions as I'm thick as 2 short planks!

Thanks for your help!

 

[Ste_Moore01]

Just so you know, this isn;t an urgent problem because I can always move the hidden rows to the bottom of the list and then if I copied the formula down it wouldn't affect it.

It was more a query than a problem.

Thanks anyway!

 

[Ste_Moore01]

Anybody got any suggestions?

 

[Peter_SSs]

Ste_Moore01

Try this:

1. Copy the formula
2. Select the whole column (or the part of it covering where the formulas have to be copied to)
3. Through the menus go Edit|Go To...|Special...|Visible Cells Only|OK
4. Paste

 

[Ste_Moore01]

Thank you very much, Peter!

That works perfectly!

I've even made myself a macro so all I have to press now is Ctrl+N!

Thanks again!