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?

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 11:40 AM.