Copy a Value Q

  • Thread starter Thread starter Seanie
  • Start date Start date
S

Seanie

How could I copy a value that is created after running some code in to
a certain cell?

My details are I run some existing code, this produces a new sheet and
a value appears in this new sheet in cell A2, this value I wish to
copy-paste special-values to Sheet1 B4

My new sheet is renamed to spmething unique each time but it will
always be created just to the right of Sheet1

Thanks
 
Seanie,

At the point at which you write the value to A2 in the 'new' sheet you could
do it then with

Range("A2").Copy
Sheets("sheet1").Range("B4").PasteSpecial , Paste:=xlPasteValues

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range(sheet2) = Range(sheet1) 11
CONCATENATE code 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
If value occurs more than once then delete all of them 8
[Q] How to create new worksheets based on an array (via named range) 4
Copy and Paste Loop 2
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Code does not error but no copy either 4

Back
Top