LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to determine the value within specific cell position?

I would like to retrieve specific cell based on the row() and column() numbers.

For example, if cell B5 contains text "Apple", which cell's position is
row()=1 and column()=2, so I would like to return the value into cell A1
based on the row and column number.

Does anyone have any suggestions on how to retrieve the value within
specific cell position?

Thanks in advance for any suggestions

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function to determine current cursor position? Dan Excel Worksheet Functions 1 March 12th 09 02:56 PM
Want to show multiple charts in one position, but determine by Lis StaceyJ Charts and Charting in Excel 2 March 7th 07 11:36 PM
how do I obtain position of specific value in a row of numbers anand Excel Worksheet Functions 5 September 17th 06 07:32 AM
Determine shape name associated with a specific cell [email protected] Excel Discussion (Misc queries) 1 May 12th 05 12:49 AM
Replacing a specific position in a cell with something else McDal Excel Discussion (Misc queries) 5 May 3rd 05 08:37 PM


All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"