Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following line:
((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? ----------------------------------------------------------------------------- Less Spam Better enjoyable experience Visit : news://spacesst.com |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Without the preceeding code I cannot be certain. Are you assigning a value to 'g', as the Cells method requires the row then column numbers rather than its alphabetic equivalent, so maybe your code should read:- ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[3,7]).Value2 = indice; -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: I have the following line: ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() That's rigth for (int g= 5102; g <= filas; g++) "Alan Moseley" wrote: Without the preceeding code I cannot be certain. Are you assigning a value to 'g', as the Cells method requires the row then column numbers rather than its alphabetic equivalent, so maybe your code should read:- ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[3,7]).Value2 = indice; -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: I have the following line: ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() According to the help screen, Value2 cannot be Currency or Date data types, but you should still see values changing. Are you sure that you are assigning indice a value before running your line of code? -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: That's rigth for (int g= 5102; g <= filas; g++) "Alan Moseley" wrote: Without the preceeding code I cannot be certain. Are you assigning a value to 'g', as the Cells method requires the row then column numbers rather than its alphabetic equivalent, so maybe your code should read:- ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[3,7]).Value2 = indice; -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: I have the following line: ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() what value does 'indice' have?? "Jean Osorio" wrote in message ... That's rigth for (int g= 5102; g <= filas; g++) "Alan Moseley" wrote: Without the preceeding code I cannot be certain. Are you assigning a value to 'g', as the Cells method requires the row then column numbers rather than its alphabetic equivalent, so maybe your code should read:- ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[3,7]).Value2 = indice; -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: I have the following line: ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft.Office.Interop.Excel.Application | Excel Programming | |||
How to let write only some simbols in the cell in Microsoft Excel | Excel Programming | |||
Namespace Microsoft.Office.Interop | Excel Programming | |||
Where can I find Microsoft.Office.Interop.Excel.dll? | Excel Programming | |||
COMException With Microsoft.Office.Interop.Excel | Excel Programming |