Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm sorry for singling you out, but you've always given me great solutions.
This piece of code will be very crucial in my application. On a spreadsheet, I have colored yellow every range that i consider to be User Input. I have also re-named each of these ranges. I want a button to create a new workbook. I want to copy the names of the ranges that are user input. I also want to copy their values. This is so later, I can call on this file and re-use this user input. One of the big issues I am encountering is that some of the Named Ranges are larger than just a single cell. I have 3 particular ranges that are 10 cells X 10 cells. Later, if the user wants to call on one of these files containing the user input, I want to cycle through the names of the ranges that we saved, and copy them back to the yellow cells of the same name. If for some reason, this yellow cell has changed names or been deleted, I want to just skip that and move to the next. Thanks for any help! Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Q4 Ron de Bruin | Excel Programming | |||
Ron de Bruin (ADO help) | Excel Programming | |||
ATT: Ron de Bruin (ADO help) | Excel Programming | |||
? for Ron de Bruin | Excel Programming | |||
for Ron de Bruin | Excel Programming |