Naming Ranges by Sheet Name

W

wutzke

Yesterday Rick
http://groups.google.com/groups/pro...GBkUAfLE0Y0lDC-XjbmU2ZJofpFIOEtJ-52xdU3vNmSJ4
show me how to sum a range of cells.

http://groups.google.com/group/micr...g/browse_thread/thread/69111afc26e643de?hl=en

I would also like to name that range and the cell that the sum total
of that range.
I can base a known range on the sheet name with

ThisWorkbook.Names.Add Name:=Worksheets(1).Name + "_data", _
RefersTo:="=$A$1:$C$10", Visible:=True

How would I use Rick's idea and also name the ranges?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top