Results 1 to 3 of 3

VBA Code needed to copy and paste the format

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2007
    Posts
    21

    Smile VBA Code needed to copy and paste the format

    Hi

    I ve a worksheet having one particular format. Everyday i ve to copy paste this format how many times i needed. Sometimes 10, sometimes 20 sometimes 50, sometimes even 150... This i am doing manually as per my requirement.

    I want a macro, whereby it automatically copy paste this format, the times i needed.

    One important thing to be noted is while copy pasting this format in the same worksheet, i ve to leave 5 rows gap between each format.

    For your reference i ve attached the excel sheet having the format.
    Attached Files Attached Files

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