Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was trying to work at the sheet level originaly but could not get
that to work. I was probably not referencing the sheets collection correctly. Looking back at your code again, its obvious there is a names collection at the sheet level as you used "Sheets("Source").Names" I think Ill go out side and rub may face on the sidewalk :) Thanks for explaining Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
trying to copy a worksheet containing named ranges to anotherworksheet | Excel Worksheet Functions | |||
Copy worksheet with named ranges to new workbook and keep names | Excel Worksheet Functions | |||
Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
copy the valued of named ranges | Excel Programming | |||
copy all named ranges in a sheet to seperate sheets | Excel Programming |