View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default How to set the value of a cell using its row and column numbers?

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?