copy active cell to same cell in sheet 2.

S

stavrosiona

New Member
Joined
Apr 17, 2015
Messages
22
I want to copy active cell if sheet 1 to same cell in sheet 2 by using vba button. Active cell is not the same each time.
I use: Range (sheet1!a2).value = range(sheet2!a2) but this does 9nly for the cell a2 and not the active cell each time.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Hi Stavrosiona,
I want to copy active cell if sheet 1 to same cell in sheet 2 by using <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">vba</acronym> button
Click to expand...

Try using "Range("Sheet2!" & ActiveCell.Address).Value = ActiveCell.Value" in your code.


Regards,
DILIPandey
 
Upvote 0
William.
This is not what was asked for. He/She want's the value in the active cell to go into the same exact cell in sheets("Sheet2")
 
Upvote 0
My answer is this is right.
I want the value in the active cell to copy into the exact same cell in sheet 2.
Can someone help on this? Is very difficult to find a solution read the active cell of sheet1 and do an action in the exact cell in sheet2.
 
Upvote 0
DILIPandey solution works for me. Did you try that stavrosiona
stavrosiona said:
My answer is this is right.
I want the value in the active cell to copy into the exact same cell in sheet 2.
Can someone help on this? Is very difficult to find a solution read the active cell of sheet1 and do an action in the exact cell in sheet2.
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Compare cells and copy
Replies
2
Views
124
AOrat
A
I
  • Question
Find last row of sheet based off cell value to reference the sheet name
Replies
0
Views
177
ItalianPlatinum
I
S
  • Question
VBA for copying a range to new sheet in same workbook
Replies
1
Views
158
NoSparks
N
P
  • Question
VBA issue. runtime 91 - only occurring after change to Range?
Replies
6
Views
199
PTEOMARK
P
A
  • Solved
Opening worksheets using worksheet names in a named range
Replies
4
Views
257
anythinggoes3949
A

Forum statistics

Threads
1,214,784
Messages
6,121,540
Members
449,038
Latest member
Guest1337

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top