Greetings,
I have issues with using the copy function with macro since i have "=" sign in my cell that needs to copied to the next sheet.
Please help.
thank you.
Greetings,
I have issues with using the copy function with macro since i have "=" sign in my cell that needs to copied to the next sheet.
Please help.
thank you.
You have not explained your problem very well.
Please provide
- your code (enclosed in code tags) and
- an example of what the code currently does and
- what you would like it to do.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
I would like to copy data from a cell on WORKSHEET A to another cell on a WORKSHEET B.
Cell O3 his a reference from Cell J9.
1.jpg
This is my code:
Range("O3").Copy Sheets("WORKSHEET B").Range("A10000").End(xlUp).Offset(1, 0)
this is the result:
#REF
Your code is copying cell O3 with formula "=J3" and pasting it to column A (in another sheet)
Try that manually (within the same sheet) and you get the same result because Excel is re-referencing the formula
-copy O3 to F3 and formula is re-referenced and becomes "=A3"
-copy O3 to anywhere in columns A:E and #REF is the result
To paste the value of cell O3:
To paste the value and cell formatting of cell O3:Please Login or Register to view this content.
To attribute the valuePlease Login or Register to view this content.
To paste the formula (=J3) without re-referencingPlease Login or Register to view this content.
Please Login or Register to view this content.
thank you very much. that was very helpful
You are welcome
Thanks for marking the thread as solved and for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks