My worksheet cells F3:DJ3 shows an individual date per cell from August 1, 2019 to December 31, 2019. Is it possible to use the date picker in which that if you click a date e.g. October 9 in the VBA date picker, it will move to cell BC3 which contains its corresponding date?
You can use Application.Goto in combination with Cells and Application.Match to find the correct column.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks