Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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(); |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I copying data from a cell on sheet to a diff cell/sheet | Excel Worksheet Functions | |||
copy a sum in cell on sheet 1 (not formula) to cell on sheet 2 | Excel Worksheet Functions | |||
copy a sum in cell on sheet 1 (not formula) to cell on sheet 2 | Excel Worksheet Functions | |||
Next time sheet is touched, remove items from cells? | Excel Discussion (Misc queries) | |||
Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc. | Excel Worksheet Functions |