| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting one worksheet cell range reference to another worksheet
I want to set one worksheet cell range reference to another worksheet
using aspose.cells.For example i have two worksheet(wrk1 and wr2). I have some data on wrk1 and wrk2 is balnk.Now on wrk2 i want cells refrence of wrk1(like want cell reference of wrk1 sheet A1:A10 on wrk2 with same style as on wrk1) . Please suggest. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting one worksheet cell range reference to another worksheet
Hi there
Try this in wrk2.("A1") =IF(wrk1!$A1="","",wrk1!$A1) Copy down to wrk2.("A10") HTH Mick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you name a worksheet by refering to a cell reference or range | Excel Discussion (Misc queries) | |||
| Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
| Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
| Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
| Setting a range value to the last cell in active worksheet. | Excel Programming | |||
Linear Mode
