Thread: [Solved] Intersect(Target, Sh.Range("AN4:AN5000")) can i reference this range another way?
View Single Post
 
Old 04-30-2021, 05:05 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
If that refers to a column in an actual Table, you can refer to it as such using something like:

Code:
Me.Listobjects("table name").Listcolumns("column header").databodyrange
for example.
Reply With Quote