I am using VBA to list the folders in a selected directory. However, the output is placed in column A, how can I have VBA prompt me to choose a column to put the information in?
Here is my code:
Declare Function SHGetPathFromIDList Lib "shell32.dll" _
Alias "SHGetPathFromIDListA" (ByVal pidl...