Return nameof Left column in current view

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Return nameof Left column in current view

FAQ

Thread Tools

Display Modes

09-19-2018, 07:58 PM

trevorc

Windows 7 32bit Return nameof Left column in current view

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

Thanks again,
But after copying your code as is nothing happened, I remove the on error line and it fails on...

Code:

 For Each oName In ActiveWorkbook.Names
   Set oRng = Range(oName.Name)

hovering over range, it shows the oname.name = <method 'range' of "object_global' failed>
hovering over oname shows it as oName.Name = "_xlfn.COUNTIFS"
oRng = nothing

perhaps oName is not pickup any names in the Activewookbook.Names

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Picture attached. Need one column to return sum of another column.	IRHSAM	Excel	3	11-18-2017 01:21 AM
Cursor Will Not Return to Left Margin	danpbphoto	Word	1	06-25-2015 07:43 PM
Return Sum value of one column from cells not blank in another column	zulugandalf	Excel	3	08-14-2014 03:37 AM
Need to search a column for a macth and return a result from a third column	pdfaust	Excel	2	02-03-2011 03:02 PM
How to return to where you left off? Shift+F5 not working.	WaltR	Word	2	12-24-2010 11:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:09 AM.