+ Reply to Thread
Results 1 to 5 of 5

Cell value and cell address to starting point to another macro

  1. #1
    Registered User
    Join Date
    05-02-2011
    Location
    Finland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Cell value and cell address to starting point to another macro

    Hi

    Need help to get cell address and use it in another macro

    I have used excel ADDRESS(MATCH)-funtion to find value and the cell address for the value.

    However this can not be used in VBA (or can it?)

    I'm using Cell.Value to get the cell address

    Please Login or Register  to view this content.
    VBA gives me errors when running this.

    All help appreciated.
    Last edited by pike; 12-20-2011 at 02:35 AM. Reason: add code tags

  2. #2
    Valued Forum Contributor mohd9876's Avatar
    Join Date
    05-04-2011
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    426

    Re: Cell value and cell address to starting point to another macro

    to get the address use the .Address property instead of .Value
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor mohd9876's Avatar
    Join Date
    05-04-2011
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    426

    Re: Cell value and cell address to starting point to another macro

    or you can define the CurrentCell as Range and use it
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-02-2011
    Location
    Finland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Cell value and cell address to starting point to another macro

    thanks for replies

    Can't use .address because I need the cell value, not the Cells(4,1) address

    or

    is there better way to find value in sheet and then get the address of that value.
    And use it as starting point?

  5. #5
    Valued Forum Contributor mohd9876's Avatar
    Join Date
    05-04-2011
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    426

    Re: Cell value and cell address to starting point to another macro

    what do you mean by
    get the address of that value
    is the address of the cell you want written in the cell(4,1)?
    in that case, your original code should work fine if the address is correct.

    could you post your workbook to see whats wrong?

+ 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