creating, concatinating, cell addresses

's Computer Specifications

I have two cells. Both contain numbers, say x and y. How do I create a cell
address that uses one of the numbers as the column and the other as the row,
i.e cell:row x,column y
--
Mal

's Computer Specifications

dim x as long
dim y as long

x = 1
y = 2
msgbox cells(x, y).value
--
HTH...

Jim Thomlinson

"Mal" wrote:

> I have two cells. Both contain numbers, say x and y. How do I create a cell
> address that uses one of the numbers as the column and the other as the row,
> i.e cell:row x,column y
> --
> Mal

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatinating one PK from one tbl & autonumber for a PK in a 2nd t	=?Utf-8?B?UmljaGFyZA==?=	Microsoft Access	7	5th Nov 2007 12:47 PM
Concatinating one PK from one tbl & autonumber for a PK in another	=?Utf-8?B?UmljaGFyZA==?=	Microsoft Word Document Management	3	31st Oct 2007 12:08 PM
Concatinating text plus cell containing date	=?Utf-8?B?TG9yaQ==?=	Microsoft Excel Worksheet Functions	2	17th Oct 2007 08:06 PM
Inserting VLookup using VBA - Problems concatinating contents of cell & variable	scott_smith@standardlife.com	Microsoft Excel Programming	5	20th Apr 2007 09:20 AM
concatinating fields		Microsoft Access	3	18th Nov 2005 12:44 AM