Loop Problems

**gandreso** · 07-06-2015, 03:00 AM

Hi!

I am very new to Macros and Vba in general so I need some help with a loop i need to do.

I need to copy the range from "U10:X" & LastRow to "Q10:T" & LastRow in a loop until the last column in row 9.
Good to know is that the LastRow will always be the same for every single loop.

In other words I need to copy cell values and replace in four columns before and then delete the original numbers with a step on 8.

My macro right now looks like this but it doesnt not work and is probably way off,

Please Login or Register  to view this content.

Would be great if someone could help me around.

Sincerely,
Niclas

**bulina2k** · 07-06-2015, 03:13 AM

try this way:

Please Login or Register  to view this content.

**Keebellah** · 07-06-2015, 03:17 AM

Hi, the code can be changed aand made easier

Please Login or Register  to view this content.

I cannot figure out what you are doing exactly but the code above works, so maybe you could try it.
Make sure you backup your sheet before you do

**gandreso** · 07-06-2015, 03:27 AM

Thank you bulina, your macro worked I just needed to change one number since i copied to many columns. This is what I got now:

Sub RefreshYear()

Dim x As Long
Dim y As Long
Dim LastRow As Long
Dim LastCol As Integer

With ActiveSheet
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
LastCol = .Cells(9, .Columns.Count).End(xlToLeft).Column
End With

For x = 21 To LastCol Step 8
y = LastRow
Range(Cells(10, x), Cells(y, 3 + x)).Copy
Range(Cells(10, x - 4), Cells(LastRow, x)).PasteSpecial xlPasteValues
Next x
End Sub

The only thing I need to add now is that the data that was copied shall be deleted.

**gandreso** · 07-06-2015, 03:29 AM

data.png
This is what the data look like. Data need to be copied from 2015 to 2014.

**bulina2k** · 07-06-2015, 03:35 AM

you should first of all use code tags #
then you should put this line just before the Next x statement:

Please Login or Register  to view this content.

Loop Problems

LinkBack

Thread Tools

Rate This Thread

Display

Loop Problems

Re: Loop Problems

Re: Loop Problems

Re: Loop Problems

Re: Loop Problems

Re: Loop Problems

Thread Information

Users Browsing this Thread

Similar Threads

Problems with IF and DO WHILE LOOP

Problems with a For Each loop

Loop Problems

problems with loop

So close! Problems with Loop

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions