- shift+ double clic sur bord d'une cellule pour selectionner toutes les cellules non vide dans cette direction
- ctrl+ double clic sur bord d'une cellule pour arriver à la dernière cellule non vide dans cette direction
-
Convert dates stored as text to dates : =DATEVALUE(cell that contains the text-formatted date that you want to convert)
-
ctrl+shift+";" pour insérer la date du jour
-
Application.WorksheetFunction.Index(rngCurrentRow.EntireRow, 1, Application.WorksheetFunction.Match("DPT", "4:4", 0)) pour utiliser une fonction Excel dans une macro
-
Pour éviter que les erreurs (N/A) détruisent les calculs:
=IF(ISERROR(cell); ""; your function(cell)) -
to find the cell that links (makes reference) to another worksheet: From "Edit, Links" you should see the path and filename that cells in your spreadsheet are linked to. Hit Ctrl-F to bring up a "Find" dialogue box, and enter the file name(s) linked to, and it should take you to the cell(s) containing the links.
-
in case the link is to another file but should point to the same cell in the current file: menu edit/links, then replace the file with the current file, then save; now the link is deleted (much faster than find/replace)
-
Tags : Excel
