Thread: [Solved] Help with setting MySelection
View Single Post
 
Old 10-14-2020, 09:23 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
You can use MySelection.CurrentRegion.Select and then click anyway in the range to select the table (as long as there is nothing around it)

Dont forget to attach example worksheets so that we dont have to try and recreate the test data
Attached Files
File Type: xlsm Help with setting MySelection_purfleet.xlsm (14.4 KB, 7 views)
Reply With Quote