Cell Ref - Link Question

[Roger]

Good Afternoon,

I have a macro that is writing from one workbook to another. After it has
finished opening and writing it's initial data, it calls this macro and
writes a special cell value to the front page. Though this works fine, I want
it to be a cell reference (linked value) vs. static.

Ive tried a couple ways unsuccessfully and was wondering if you might have
some ideas on how to accomplish this.

Thank you - Roger

Sub WritetoMainPage()

Dim irow As Long
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")

irow = ws.Cells(1, 12) _
.End(xlDown).Offset(1, 0).Row

ws.Cells(irow, 12) = ActiveSheet.Range("h5").Value <<<This works but I want
a cell ref (link) vs. static value>>>

Worksheets("sheet1").Select

End sub

 

[George Hepworth]

Inasmuch as this is discussion group is devoted to MS Access, the datbase
application which is part of MS Office along with MS Excel, you'd probably
have more success getting a useful response by posting this question in an
Excel discussion group.

George

 

[Douglas J. Steele]

Sorry, this newsgroup is for questions about Access, the database product
that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.

 

[Jerry Whittle]

I believe that you are in the wrong discussion group. This one is for
Microsoft Access database problems and not Excel.