Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Ref question
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 Was this post helpful to you? Why should I |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
Cell question | Excel Worksheet Functions | |||
Excel cell question | Excel Discussion (Misc queries) | |||
Yet another cell color question. | Excel Discussion (Misc queries) | |||
empty cell question | Excel Worksheet Functions |