+ Reply to Thread
Results 1 to 4 of 4

vba code for setting the cell value to be equal to cell value in another workbook

  1. #1
    Registered User
    Join Date
    11-05-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    59

    vba code for setting the cell value to be equal to cell value in another workbook

    e.g. I want Cells(1,1) to be equal to [anotherworkbook.xls]anotherworksheet'!Cells(1,1)
    How should I write the code.

    Thanks guys

  2. #2
    Forum Contributor
    Join Date
    07-07-2005
    Location
    England
    MS-Off Ver
    2003 Pro
    Posts
    459

    Re: vba code for setting the cell value to be equal to cell value in another workbook

    This seems to work good even when the other workbook is closed
    Please Login or Register  to view this content.

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,647

    Re: vba code for setting the cell value to be equal to cell value in another workbook

    ='E:\[address.xls]Sheet1'!A1



  4. #4
    Registered User
    Join Date
    11-05-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    59

    Re: vba code for setting the cell value to be equal to cell value in another workbook

    Hey experts,
    I need to a macro/vba that replicate the action the pressing the downarrow key.
    So that when my spreadsheet is grouped/ungrouped, when e downarrow key is pressed, it may select a different cells.
    e.g. when row 8 to 10 is grouped, current active cell at cells(7,1), when pressing downarrow, it will select cells(10,1).
    thanks!

+ 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