LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Basz
 
Posts: n/a
Default Accessing named ranges in Excel from VBA


Can anyone tell me if and how I can access a named range on a worksheet
in a VBA procedure?

The value of the cell is read from a record with vlookup, I need to be
able to access it in a procedure in VBA as input in a new record.

Thankx,
Basz


--
Basz
------------------------------------------------------------------------
Basz's Profile: http://www.excelforum.com/member.php...o&userid=12340
View this thread: http://www.excelforum.com/showthread...hreadid=394589

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Excel database into Outlook Contacts says "No Named Rang Bryan Excel Discussion (Misc queries) 13 December 17th 09 10:23 PM
Calculating with named ranges KG Excel Discussion (Misc queries) 2 May 13th 05 02:52 PM
Named ranges - column/row question Carole O Excel Discussion (Misc queries) 5 May 11th 05 02:40 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM
vlookup and named ranges chathag Excel Worksheet Functions 3 November 22nd 04 04:07 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"