Camera Tool Problem

[cattinella]

Trying to figure out why when I use the camera tool to copy a range the past result is "cropped". The formula bar indicates the proper range however only about 50% of the range is displayed

 

[James006]

Hi,

First step is to select your initial range ...

Then click on the Camera icon ...

And finally click at the destination cell ...

HTH

 

[cattinella]

That is what I am doing, and for the past 4 years that has worked fine, but now when I paste it doesnt paste the entire range, only a portion.

 

[James006]

That is what I am doing, and for the past 4 years that has worked fine, but now when I paste it doesnt paste the entire range, only a portion.

Have a look at the following : A New Excel 2010 Camera Tool Bug, and a Workaround

HTH