cell address
From: mike allen (mikeallen77_at_charter.net)
Date: 06/16/04
- Next message: Sea: "Re: formulas not executing until workbook is saved"
- Previous message: The Grinch: "running a macro only if criteria are met"
- Next in thread: Pete McCosh: "cell address"
- Reply: Pete McCosh: "cell address"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Jun 2004 09:08:08 -0500
i have an array in cells f8:n16 with letters across top row and numbers
along left column. these numbers and letters are not in any particular
order. the middle of this array has various information that i need to
retrieve, given a letter (that is on top row) and number (that is on left
column). i would like the cell address (row and column numbers) of the
intersection of these 2 inputs. example: 1st input = p, 2nd input=7. p is
in column m, or 13th row in spread***, while 7 is in row 15. thus, i
would like to have cells(15,13) as my answer, which would correspond w/ what
i am trying to retrieve. thanks, mike allen
- Next message: Sea: "Re: formulas not executing until workbook is saved"
- Previous message: The Grinch: "running a macro only if criteria are met"
- Next in thread: Pete McCosh: "cell address"
- Reply: Pete McCosh: "cell address"
- Messages sorted by: [ date ] [ thread ]