Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro Taget File Name (2000 SP 3)

    I want to create a macro that copies the value from a cell in a target worksheet into the cell in my destination worksheet. Trouble is that the target worksheet file name is always referenced in the macro. This macro will need to work with different workbooks as the target. I know there is something used called

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

    Re: Macro Taget File Name (2000 SP 3)

    You can use ActiveWorkbook.ActiveSheet to refer to the active sheet in the active workbook.

Posting Permissions

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