Results 1 to 5 of 5

Thread: Excel - paste special values

Threaded View

  1. Mar 23rd, 2005, 11:00 AM #1
    salvelinus
    salvelinus is offline

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Resolved Excel - paste special values

    Is there a way to automatically select all formulas in a worksheet and do a paste special, replacing the formulas with their values, in code?
    Basically, we have an Access db that creates an Excel worksheet, and then other people in the company do whatever they do with it. They don't want any formulas in the worksheet though, although they're needed to calculate the values. I have pretty limited experience with Excel programming. Thanks.
    Last edited by salvelinus; Mar 24th, 2005 at 11:37 AM.
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width