|
|
#1
02-28-2021, 01:05 PM
|
|||
|
|||
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
Trevor 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| PIVOT TABLES adding several FILTERS that do not intersect between them | Squall LH | Excel | 0 | 11-09-2017 08:46 AM |
| Return the value of a cell | piper7971 | Excel | 4 | 06-09-2015 03:00 PM |
| How to return the first cell in a row? | dapeamel | Excel | 0 | 02-26-2015 12:56 AM |
| Would like to return a row rather than a cell using VLookup | canajun | Excel | 7 | 12-10-2014 01:03 PM |
| Intersect | tinfanide | Excel Programming | 1 | 07-27-2014 06:14 AM |
using Intersect to return cell value
Windows 7 32bit 
Office 2013
Threaded Mode