Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2021, 01:05 PM
trevorc trevorc is offline using Intersect to return cell value Windows 7 32bit using Intersect to return cell value Office 2013
Competent Performer
using Intersect to return cell value
 
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
  #2  
Old 02-28-2021, 10:34 PM
Purfleet Purfleet is offline using Intersect to return cell value Windows 10 using Intersect to return cell value Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

can you post an exmaple workbook? We have no idea what other data is there or where it is looking
Reply With Quote
  #3  
Old 03-02-2021, 08:29 PM
trevorc trevorc is offline using Intersect to return cell value Windows 7 32bit using Intersect to return cell value Office 2013
Competent Performer
using Intersect to return cell value
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

Thanks for the reply, but I'm passed this now, I just filtered on Customer name then continued my VBA.
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft