+ Reply to Thread
Results 1 to 2 of 2

copying data using a macro

  1. #1
    Registered User
    Join Date
    02-12-2008
    Posts
    1

    copying data using a macro

    My situation is that i need to copy data from one sheet to another. The data i am copying is to be added to a defined range. However this means that i need to use OFFSET in my macro so that i can add it to the next Available row and not a used one. However i do not no how to incorporate the offset into my macro.

    Range("I10").Select
    Selection.Copy
    Sheets("Customers").Select
    Range ("b16")
    ActiveSheet.Paste
    End Sub

    This is what i have so far and would like to copy the data to the next available row and not a set one that will aventualy be used.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    You could try this:
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    Last edited by StephenR; 02-12-2008 at 01:08 PM.

+ Reply to Thread

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