Try the link below:
http://www.ozgrid.com/News/excel-validation-tips.htm
Norman
On Thu, May 28, 2009 at 12:09 PM, Ahmet Yalcin wrote:
> Hello Paul,
>
> Thank you. What I am trying is to gather data from same address on many
> sheets in my workbook. The name of the file is 2008-04 BIL.xls and
Hello Paul,
Thank you. What I am trying is to gather data from same address on many
sheets in my workbook. The name of the file is 2008-04 BIL.xls and within I
have sheets called KM, KS and KD (of course this is just a representative
picture of a larger project). Can you kindly suggest what I
you're trying to "insert the sheet name"???
I assume the . . . is including code that is selecting a different cell.
so the ActiveCell for loop x = 1 is different than the Active Cell when x = 3.
try recording a macro.
Also, keep in mind that when you declare an array,
the indexes start at 0, no
I'm not sure if this will work.
Try replacing the + with &
Norman
On Thu, May 28, 2009 at 10:19 AM, Ahmet Yalcin wrote:
> Hello,
>
> Please help me with the right syntax writing the below
> ActiveCell.FormulaR1C1 = "='[2008-04 BIL.xls]+Company(x)'!D7" line. I wish
> to insert the Sheet name as