I have a worksheet which collects data from several other worksheets in the
same workbook, this data is collected by a user form. The user form then
writes this data to a worksheet, one row at a time I have saved the row and
column value that originally wrote the data to the collecting sheet and the
worksheet name. My problem is, that sometimes I need to return to the
originateing cell to make changes, thought I might be able to use
Cells(Row,Column) or a hyperlink, trouble is I don't know how! I have looked
in the help file but to no avail. Please can anyone help. Many thanks Graham

Worksheet("worksheetname").cells(row,column)=myval ue

<worksheetnameyour workshhet name
<myvalue data to be saved

Worksheet("worksheetname").cells(row,column).selec t

will select the cell

HTH
"Graham F" wrote:

I have a worksheet which collects data from several other worksheets in the
same workbook, this data is collected by a user form. The user form then
writes this data to a worksheet, one row at a time I have saved the row and
column value that originally wrote the data to the collecting sheet and the
worksheet name. My problem is, that sometimes I need to return to the
originateing cell to make changes, thought I might be able to use
Cells(Row,Column) or a hyperlink, trouble is I don't know how! I have looked
in the help file but to no avail. Please can anyone help. Many thanks Graham

Many thanks toppers, brilliant as usual. Works a treat! Best wishes Graham

"Toppers" wrote:

Worksheet("worksheetname").cells(row,column)=myval ue

<worksheetnameyour workshhet name
<myvalue data to be saved

Worksheet("worksheetname").cells(row,column).selec t

will select the cell

HTH
"Graham F" wrote:

I have a worksheet which collects data from several other worksheets in the
same workbook, this data is collected by a user form. The user form then
writes this data to a worksheet, one row at a time I have saved the row and
column value that originally wrote the data to the collecting sheet and the
worksheet name. My problem is, that sometimes I need to return to the
originateing cell to make changes, thought I might be able to use
Cells(Row,Column) or a hyperlink, trouble is I don't know how! I have looked
in the help file but to no avail. Please can anyone help. Many thanks Graham