Copy / Paste Macro

[chet645]

I am trying to use the more efficient way to copy and paste values using a looping macro. The code below doesn't seem to be doing what I want it to. I don't get an error with the line of code below, yet when I run the macro, it doesn't paste my values at all.

Range("Land_Paste").Offset(Macro, 0).Value = Range("Land_Copy")

Here is my entire Macro:

Dim Macro As Integer
Dim A As Integer
Dim B As Integer


A = Range("Macro_Start")
B = Range("Macro_End")


For Macro = A To B Step 1


Range("Macro_No").Value = Macro


Range("Min_Delta").GoalSeek Goal:=0, ChangingCell:=Range("Land_Value")

Range("Land_Paste").Offset(Macro, 0).Value = Range("Land_Copy")

Next Macro


Any help would be much appreciated!!!! Thanks in advance.

Chet

 

[My Aswer Is This]

Chet:

You need to tell us what your want to do instead of showing us a script which is not working and wanting us to figure out what your wanting

Tell us in words with specific details what your wanting to do

 

[chet645]

Chet:

You need to tell us what your want to do instead of showing us a script which is not working and wanting us to figure out what your wanting

Tell us in words with specific details what your wanting to do

Sorry, just want the macro to paste the values, lol.

 

[My Aswer Is This]

That is not providing details.

Sorry, just want the macro to paste the values, lol.

 

[hiker95]

chet645,

We can not tell where your raw data is located, sheet name(s), cells, cell formatting, cell formulae, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, cell formulae, rows, columns.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729