#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
can you post an exmaple workbook? We have no idea what other data is there or where it is looking
|
#3
|
|||
|
|||
Thanks for the reply, but I'm passed this now, I just filtered on Customer name then continued my VBA.
|
|
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 |