+ Reply to Thread
Results 1 to 3 of 3

Copying cell data without the formula

  1. #1
    Registered User
    Join Date
    05-06-2004
    Posts
    60

    Copying cell data without the formula

    Hello,
    I would like to copy a cell range (Column D) from 1 sheet and paste to the same cell range of another sheet without carrying over the formula. Any help would be great !

    Thanks,
    Oreg

  2. #2
    Forum Contributor
    Join Date
    01-21-2005
    Location
    Colorado
    MS-Off Ver
    2000,2003,2007
    Posts
    481
    Use paste special and paste as values.

    Record a macro while doing this manually to see the correct syntax.

    HTH

  3. #3
    Registered User
    Join Date
    05-06-2004
    Posts
    60
    Thanks bhofsetz, Worked perfectly!

+ 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