Last cell touched on sheet
 

What can I do to have the last cell touched on the sheet saved using code?
The code below does not retain B37 as the last cell even though this code is
right at the end before saving the workbook. Instead the last cell touched is
retained as the last one the user clicked on ... which is very annoying and
messy looking. Thanks.

excel.Range rg37 = null;
rg37.get_Range("B37", "B37");
rg37.Font.ColorIndex =
clsStatic.ColorCodes.white;
rg37.Value2 = dtRunDate.ToShortDateString();
rg37.Select();

Last cell touched on sheet
 

What programming language are you using?
What version of Excel are you using?
Where is the code located?
--
Jim Cone
Portland, Oregon USA



"cupboy"
wrote in message
What can I do to have the last cell touched on the sheet saved using code?
The code below does not retain B37 as the last cell even though this code is
right at the end before saving the workbook. Instead the last cell touched is
retained as the last one the user clicked on ... which is very annoying and
messy looking. Thanks.

excel.Range rg37 = null;
rg37.get_Range("B37", "B37");
rg37.Font.ColorIndex = clsStatic.ColorCodes.white;
rg37.Value2 = dtRunDate.ToShortDateString();
rg37.Select();

Last cell touched on sheet
 

It's Visual C# and excel object library 11. Code is located in Utah.
It fails on the Select() but gives no useful info. I've also tried Activate().
Just give me VBA code and I'll convert it over to what I use.

"Jim Cone" wrote:

What programming language are you using?
What version of Excel are you using?
Where is the code located?
--
Jim Cone
Portland, Oregon USA



"cupboy"
wrote in message
What can I do to have the last cell touched on the sheet saved using code?
The code below does not retain B37 as the last cell even though this code is
right at the end before saving the workbook. Instead the last cell touched is
retained as the last one the user clicked on ... which is very annoying and
messy looking. Thanks.

excel.Range rg37 = null;
rg37.get_Range("B37", "B37");
rg37.Font.ColorIndex = clsStatic.ColorCodes.white;
rg37.Value2 = dtRunDate.ToShortDateString();
rg37.Select();

Last cell touched on sheet
 

Just give me VBA code and I'll convert it over to what I use.

Why not give us the VBA code that fails, if necessary with any other steps
required to replicate.

Regards,
Peter T

"cupboy" wrote in message
...
It's Visual C# and excel object library 11. Code is located in Utah.
It fails on the Select() but gives no useful info. I've also tried
Activate().
Just give me VBA code and I'll convert it over to what I use.

"Jim Cone" wrote:

What programming language are you using?
What version of Excel are you using?
Where is the code located?
--
Jim Cone
Portland, Oregon USA



"cupboy"
wrote in message
What can I do to have the last cell touched on the sheet saved using
code?
The code below does not retain B37 as the last cell even though this code
is
right at the end before saving the workbook. Instead the last cell
touched is
retained as the last one the user clicked on ... which is very annoying
and
messy looking. Thanks.

excel.Range rg37 = null;
rg37.get_Range("B37", "B37");
rg37.Font.ColorIndex = clsStatic.ColorCodes.white;
rg37.Value2 = dtRunDate.ToShortDateString();
rg37.Select();

Last cell touched on sheet
 

Here is the corrected code. I had to Activate the sheet first, before I could
do the Select. That's all that was wrong with it.

excel.Range rg37 = w.get_Range("B37", "B37");
rg37.Font.ColorIndex = clsStatic.ColorCodes.white;
rg37.Value2 = dtRunDate.ToShortDateString();
w.Activate();
rg37.Select(); // 'Can't select unless the sheet
is active
// refer to
http://msdn.microsoft.com/en-us/library/bb178282.aspx


"Peter T" wrote:

Just give me VBA code and I'll convert it over to what I use.

Why not give us the VBA code that fails, if necessary with any other steps
required to replicate.

Regards,
Peter T

"cupboy" wrote in message
...
It's Visual C# and excel object library 11. Code is located in Utah.
It fails on the Select() but gives no useful info. I've also tried
Activate().
Just give me VBA code and I'll convert it over to what I use.

"Jim Cone" wrote:

What programming language are you using?
What version of Excel are you using?
Where is the code located?
--
Jim Cone
Portland, Oregon USA



"cupboy"
wrote in message
What can I do to have the last cell touched on the sheet saved using
code?
The code below does not retain B37 as the last cell even though this code
is
right at the end before saving the workbook. Instead the last cell
touched is
retained as the last one the user clicked on ... which is very annoying
and
messy looking. Thanks.

excel.Range rg37 = null;
rg37.get_Range("B37", "B37");
rg37.Font.ColorIndex = clsStatic.ColorCodes.white;
rg37.Value2 = dtRunDate.ToShortDateString();
rg37.Select();

Last cell touched on sheet
 

You might want to activate the workbook too, just in case.

Regards,
Peter T

"cupboy" wrote in message
...
Here is the corrected code. I had to Activate the sheet first, before I
could
do the Select. That's all that was wrong with it.

excel.Range rg37 = w.get_Range("B37", "B37");
rg37.Font.ColorIndex =
clsStatic.ColorCodes.white;
rg37.Value2 = dtRunDate.ToShortDateString();
w.Activate();
rg37.Select(); // 'Can't select unless the
sheet
is active
// refer to
http://msdn.microsoft.com/en-us/library/bb178282.aspx


"Peter T" wrote:

Just give me VBA code and I'll convert it over to what I use.

Why not give us the VBA code that fails, if necessary with any other
steps
required to replicate.

Regards,
Peter T

"cupboy" wrote in message
...
It's Visual C# and excel object library 11. Code is located in Utah.
It fails on the Select() but gives no useful info. I've also tried
Activate().
Just give me VBA code and I'll convert it over to what I use.

"Jim Cone" wrote:

What programming language are you using?
What version of Excel are you using?
Where is the code located?
--
Jim Cone
Portland, Oregon USA



"cupboy"
wrote in message
What can I do to have the last cell touched on the sheet saved using
code?
The code below does not retain B37 as the last cell even though this
code
is
right at the end before saving the workbook. Instead the last cell
touched is
retained as the last one the user clicked on ... which is very
annoying
and
messy looking. Thanks.

excel.Range rg37 = null;
rg37.get_Range("B37", "B37");
rg37.Font.ColorIndex = clsStatic.ColorCodes.white;
rg37.Value2 = dtRunDate.ToShortDateString();
rg37.Select();