|
|
#3
01-06-2023, 04:01 PM
|
|||
|
|||
You can also use CurrentRegion, which is like pressing CTRL+* in a range, and may be better depending on the source of the data/workbook. TABLES are generally better.
Code:
MyTableasRange = MyWorksheet.Range("A1").CurrentRegion
and MyWorkSheet is DIM as a Worksheet and defined to the desired worksheet where the table resides. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Can a Macro be run such that by which an Excel table (one is created by ctrl+t) be “Pasted Link” to
|
soroush.kalantari | Word VBA | 3 | 09-21-2021 11:48 PM |
| How to remove space between header and first bullet in Outlook email created by Excel macro | kevinbradley57 | Excel Programming | 1 | 03-27-2019 08:39 PM |
| Forms created in Word | Johnmcl | Word | 7 | 11-25-2015 07:01 PM |
|
Pre Created Form help
|
SRKS72 | Word | 4 | 08-30-2014 03:57 PM |
| mtg/appt. created - enter into SQL db also | manared | Outlook | 0 | 02-07-2011 11:04 AM |
Windows 10 
Office 2021
Threaded Mode