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();
|