View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Zone[_3_] Zone[_3_] is offline
external usenet poster
 
Posts: 373
Default Which Sheet Is Named Range On?

Wow, super advice! Thanks, Chip, Gary and Gary''s. Chip, your
example worked perfectly for me. But I will study all the replies!
Tally-ho! James

On Jun 22, 3:40?pm, "Chip Pearson" wrote:
Try something like

With Range("TheName")
.Worksheet.Select
.Worksheet.Cells(1, .Column).EntireColumn.Select
End With

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consultingwww.cpearson.com
(email on the web site)

"Zone" wrote in message

oups.com...



I have a workbook with several worksheets. Each worksheet has many
named ranges (single-cell ranges, all in row 1). I want to specify a
range name and have my subroutine activate the sheet containing the
range name and select the column containing the range name.
Thanks, James- Hide quoted text -


- Show quoted text -