Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Dim c As Range For Each c In ActiveSheet.UsedRange.columns("A").Cells c.Value = CDate(c.Value) Next c
Sub TilDato() For Each c In Selection.Cells c.Value = Replace(c.Value, ".", "-") c.NumberFormat = "dd-mm-yyyy" Next c End Sub
|Using an Average(IF statement to return values from closed external workbooks||5||19|
|Access VBA - selected Item in Listbox (multiselect) - value of ONE item selected||4||36|
|Excel. How to get via VBA the last used row in a named dynamic range||10||35|
|How best to represent data in Excel?||13||25|