View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Marc Marc is offline
external usenet poster
 
Posts: 70
Default How to set the value of a cell using its row and column number

Thanks Chip,

this is exactly what I wanted. Would like just to confirm that no Excel
Function could do this action.

Regards,
Marc

"Chip Pearson" wrote:

Marc,

If you have a row number and column number, you can use something
like

Cells(row_num,col_num).Value = 123


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Marc" wrote in message
...
If I have the row and column number s of a cell (calculated in
one part of
the worksheet) how can I set the value of this cell to the
value I want.
This is usally done in Access by setvalue for a control. so you
send data to
the place you want. Is this feasible in Excel and how?