In a workbook, have data sheet and report sheet.
In the report sheet at cell N1=If(data!B3:H3=1,1,0)
In cell P1=2
How can I substitute the value of P1 into the range so that the formula
will become something like N1=If(data!"B" &P1+1:"H" &P1+1=1,1,0). I
need to do this to because when I change the value in P1, N1 will give
me the answer instantly instead of changing the formula range every
time.

Can a worksheet (A.xls) defines reference to a worksheet(B.xls) for
data that is not open/used?

In VBA how do I define to use a closed workbook (A.xls) to extract data
and write to current open workbook (B.xls)?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/