How to set the value of a cell using its row and column numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Thanks Chip,

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

Regards,
Marc
 
Back
Top