+ Reply to Thread
Results 1 to 2 of 2

Optimize VBA code

  1. #1
    Registered User
    Join Date

    Optimize VBA code

    Hi Guys,

    I have written some code (below), which does what i need it to, but is slow. Its a straightforward code to populate the next row in a spreadsheet, which i am using as a database. Unfortunately there are a lot of columns (A - EO). As you can see the code i have writes each cell using anchor_cell.offset method.

    Please Login or Register  to view this content.
    I was wondering if there is any way this code can be optimized to run quicker?
    Any help would be greatly appreciated.

    Best regards

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    Melbourne, Australia
    I do not know how much speed difference this makes but I would normally use

    Please Login or Register  to view this content.
    If you need or want to use offset then use

    Please Login or Register  to view this content.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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