Return nameof Left column in current view

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 02:29 PM.