Return Path to previous cell

[Graham F]

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

 

[Toppers]

Worksheet("worksheetname").cells(row,column)=myvalue

<worksheetname>your workshhet name
<myvalue> data to be saved

Worksheet("worksheetname").cells(row,column).select

will select the cell

HTH

 

[Graham F]

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