ActiveCell.EntireRow Problem

**Slyone2** · 07-29-2010, 12:19 AM

Please Login or Register  to view this content.

Uses the entire row.... Adds many unneeded col.

Please Login or Register  to view this content.

This adds alot of #NA's to sheet.

How can I fix, I only want range/cells in A160 to BZ160.

Thanks....

**royUK** · 07-29-2010, 01:24 AM

Don't use EntireRow.

Please Login or Register  to view this content.

Is the sheet called 1?

**Slyone2** · 07-29-2010, 11:05 AM

Please Login or Register  to view this content.

Any idea on copy paste without clipboard on this nasty.

**Slyone2** · 07-29-2010, 11:26 AM

Please Login or Register  to view this content.

This copy's formula's, I need values

**royUK** · 07-29-2010, 11:32 AM

Maybe you sg] should state what you want at the start not after answers have been given!

Please Login or Register  to view this content.

**Slyone2** · 07-29-2010, 11:44 AM

Please Login or Register  to view this content.

Didnt work. My first method gave me values. This still give formula's.

**Slyone2** · 08-09-2010, 11:48 PM

anyone on this?

Re: ActiveCell.EntireRow Problem