I've made the following to autofit the row of the cell I selected, but I want it to be the origin row height after another cell is selected.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.EntireRow.AutoFit
End Sub
Is there anyway to get folders' name and file name into spreadsheet automaticly? like this.
MyDoc
Pics
Colleagues
Remond.jpg
Steve.jpg
Family
Friends
Memos
Kids
Lucy
Business
Meeting
There may be a file in Windows System, but I don't know which one.
I am creating a database which for inventory items stock. Is that possible to show the date and time in a cell of the same row where and when I input stock information?
Can a validation list in a cell is controled by another cell?
For example: if in cell "A1" is "Fruit", then the validation list in cell "B1" will be "Apple", "Pear", "Orange"; if in cell "A1" is "Furniture", the the calidation list in cell "B1" will be changed to "Table", "Chair", "Sofa".
I...