vba paste not working

Solution 1:

The reason it fails on that line of code is that there is no Paste method for the Range object.

There are 2 ways to copy paste.

1) Send a value to the Destination parameter in the Copy method. You then don't need a Paste command: wb.Sheets("Answers_Source").Range("h1:z160").Copy _ Destination := wb2.Sheets("Answers").Range("h1:z160")

2) Use the PasteSpecial method on the destination range after copying, which by default pastes everything, like a standard paste.

wb2.Sheets("Answers").Range("h1:z160").PasteSpecial

Then to stop the Marquee (or marching ants) around the cell you copied, finish with Application.CutCopyMode = False

Solution 2:

Try removing these With which anyway make no sense in the context.

   'do copy from reference "Answers_Source" worksheet
   wb.Sheets("Answers_Source").Range("h1:z160").Copy

   'now paste the formulas into the student exam workbook
   wb2.Sheets("Answers").Range("h1:z160").Paste

How to implement batch fetching with Fluent NHibernate when working with Oracle?

Auto Login Dropbox account on Core Api without Login Prompt

sum specific values in a multidimensional array (php)

Using JInternalFrame and some button

Create an On-screen Keyboard

Does every ring with unity arise as an endomorphism ring?

Show $ \varlimsup_{n\rightarrow\infty}{\sqrt[n]{a_{1}+a_{2}+\cdots+a_{n}}}=1 $ if $\displaystyle \varlimsup_{n\rightarrow\infty}{\sqrt[n]{a_{n}}}=1 $

Calculate: $\lim\limits_{x \to \infty}\left(\frac{x^2+2x+3}{x^2+x+1} \right)^x$

Does there exist a topology for a set $X$ which is compact and Hausdorff?

Does $\mathsf{ZFC} + \neg\mathrm{Con}(\mathsf{ZFC})$ suffice as a foundations of mathematics?

Is it possible to prove the positive root of the equation ${^4}x=2$, $x=1.4466014324...$ is irrational?

Could we show $1-(x-\frac{x^3}{3!}+\frac{x^5}{5!}-\dots)^2=(1-\frac{x^2}{2!}+\frac{x^4}{4!}- \dots)^2$ if we didn't know about Taylor Expansion?