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: 149
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