Results 1 to 7 of 7

Optimize code

Threaded View

miso.dca Optimize code 02-08-2011, 01:43 PM
jeffreybrown Re: how to optimalize code? 02-08-2011, 01:58 PM
miso.dca Re: how to optimalize code? 02-08-2011, 02:06 PM
jeffreybrown Re: how to optimalize code? 02-08-2011, 02:41 PM
miso.dca Re: how to optimalize code? 02-08-2011, 02:50 PM
jeffreybrown Re: how to optimalize code? 02-08-2011, 03:16 PM
miso.dca Re: how to optimalize code? 02-08-2011, 03:35 PM
  1. #1
    Forum Contributor
    Join Date
    07-26-2009
    Location
    Slovakia
    MS-Off Ver
    Excel 2019
    Posts
    244

    Optimize code

    Hello,
    I have this code
    Sub blabla
    pocet = Range("B" & Rows.Count).End(xlUp).Row
        For i = 1 To pocet Step 3
            Range("A" & i & ":B" & i).Cut
            ii = i + 1
            Range("F" & ii).Select
            ActiveSheet.Paste
            iii = i + 2
            Range("B" & iii).Cut
            Range("B" & ii).Select
            ActiveSheet.Paste
        Next
    End Sub
    it works, but it's really slow ... I have more than 1000 rows and this code is really really slow ... it is possible to change it and macro will be faster? thanks for any help !
    Last edited by miso.dca; 02-08-2011 at 03:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1