Intersect(Target, Sh.Range("AN4:AN5000")) can i reference this range another way?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Intersect(Target, Sh.Range("AN4:AN5000")) can i reference this range another way?

trevorc Intersect(Target,... 03-02-2021, 08:36 PM

trevorc Sorted, i can just give the... 03-02-2021, 08:43 PM

Debaser If that refers to a column in... 04-30-2021, 05:05 AM

03-02-2021, 08:43 PM

trevorc

Windows 7 32bit Intersect(Target, Sh.Range("AN4:AN5000")) can i reference this range another way?

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

Sorted, i can just give the column a reference and use that, works while in the table.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Declare wBk as workbook. Set wBk = workbooks("NewBook.xls") gives error: Subscript out of range.	Syed Shabbir	Excel Programming	1	09-27-2020 09:35 AM
The "group or ungroup text range" control in the developer tab breaks my document up into many pages	damiansiniakowicz	Word	8	05-10-2018 12:30 PM
Workarounds for the find "dynamic" range bug in VBA?	Robert K S	Word VBA	2	11-07-2016 01:00 PM
Making cross-reference say "Fig." instead of "Figure"	dgalb	Word	17	11-09-2014 06:25 AM
Mysterious "Subscript out of range" error	rnstewart	Excel	4	12-29-2005 01:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 AM.