| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Addresses Instead of Values
Nel post
*John* ha scritto: I have a nice excel macro below that passes cell values on Input sheet (Ins) to Output sheet (OS). The macro examines Output sheet Column A for rows having some ..... and then writes the appropriate InS row values to the ..... row. When 1 InS row is written the macro increments to the next correct row pairs. It works nicely with 20,000 row input sheets. I want to alter the macro below so that an address is passed rather that a value and leaves the InS and OS permanently linked. Verbally put: InS.Range(InS.Cells(datarow, "A"), InS.Cells(datarow, "E")).Copy Destination:=OS.Cells(i, "C") needs to be altered to permanently write the correct cell addresses rather than cell values. Thanks ahead of time, John Hi John, I'm not sure, but I think you could use this line of code to link the two cells: OS.Cells(i, "C").Formula = "=" & InS.Range(InS.Cells(datarow, "A"), InS.Cells(datarow, "E")).Address -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing values in Sheet to VBA | Charts and Charting in Excel | |||
| Passing values | Excel Programming | |||
| Please help with passing values | Excel Programming | |||
| Passing Values | Excel Programming | |||
| Passing values to new app | Excel Programming | |||
Threaded Mode
