Hi The
In my workbook, name of 2 worksheets are a_data & a_report. I am
getting correct result when I am using the following in another trial
sheet:
Sheets("Sheet2").Cells(1,1).Formula="=SUMIF(Sheet1 !A:A,0,Sheet1!B:B)".

But when I am using my original workbook code with the original name as
follows, its giving run-time error.:
Sheets("a_report").Cells(1,1).Formula="=SUMIF(a_da
ta!A:A,0,a_data!B:B)"

--why the reference creating problem when I am chanhging just the sheet
name from Shee1 to a_data.
Thanks in advance.


--
jesmin
------------------------------------------------------------------------
jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540
View this thread: http://www.excelforum.com/showthread...hreadid=508357