Menu
![]() How I would convert this to work on Mac 2011? Code: Columns('AI:AI').Select Selection.TextToColumns Destination:=Range('AI1'), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _. ![]() My VBA which works fine on Excel 2007/2010 does not work on Excel for Mac 2011. Ie I need the user to be able to select a date from a calendar for all the cells with the same column (Cloumn A). However I need this selection to be reapeated for an entire row. ![]() I have followed the following steps: Developer, Insert, More Controls, Microsoft Date and Time Picker Control 6.0 (SP4) and dragged the box wherever in the sheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |