Copy and paste to Macro

  • Thread starter Thread starter Intruder9
  • Start date Start date
I

Intruder9

If I had the following code in a macro

Range("B1").Select
Application.CutCopyMode = False
Selection.Copy
ActiveWindow.SmallScroll ToRight:=6
Range("K1").Select
ActiveSheet.Paste

Is there a way to copy a cell that contained for example
A10= Application.CutCopyMode= True

and paste it over the line of code that states

Application.CutCopyMode = False

What I would like to be able to do is be able to change a line of code by
what is in a cell. This is the example I used to illistrate but not the
actual code being replaced.
Thanks
 
VBA, and any other compiled language, will not let you do this.
However, you could do something like:

Application.CutCopyMode = Range("A10").Value

where you put TRUE or FALSE into A10.
 
Back
Top