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. |
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 |
All times are GMT +1. The time now is 12:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com