copying fields

Computerised10

New Member
Joined
Oct 2, 2014
Messages
20
Hi

im recording a macro, but when i copy a field on the macro i dont want it to be definate the next timei run it, i just want it to copy from whatever is in cell a1 to a2 no matter whats there.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,430
Office Version
  1. 365
Platform
  1. Windows
Like this maybe:

Code:
Sub t()
Range("A1").Copy Destination:=Range("A2")
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,109,522
Messages
5,529,330
Members
409,863
Latest member
stacy09
Top