Thread: [Solved] using Intersect to return cell value
View Single Post
 
Old 02-28-2021, 01:05 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
  
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default using Intersect to return cell value
trying to get the value of a cell using the code below, but it just returns subscript out of range. Can anyone help or offer another solution to this please.

Code:
if Intersect(ActiveCell.EntireRow, tblColumns("Customer Name = ""Australia""").Value) Then
regards
Trevor
Reply With Quote