Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA - Macros (Excel 2000)

    What I am trying to do is to paste the value of each cell within a defined range into a cell in another worksheet then print the worksheet. The cell that I am pasting into is the reference point for lookups and I need it to lookup the new data and then print the view. I am able to record a macro to copy, paste, print but the range is 200 cell and that is a lot of redundant Macroing.

    Are you aware of a formula to copy paste and print a range of cells repeatedly?

    Any additional information would be greatly appreciated.

    Thanks !!!

    Happy Thanksgiving [img]/forums/images/smilies/smile.gif[/img]

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA - Macros (Excel 2000)

    Is this a follow-up to <post:=536,686>post 536,686</post:> ? You didn't react to the replies given there.

Posting Permissions

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